Create a stochastic model in Excel for a manufacturing operation. The machine is cutting rectangular cube blanks for a forming process. The stock material is uniformly 0.50 inch thick. Two cutting processes are needed. The blanks are cut to an average width of 4.74 inches, and are normally distributed with a standard deviation of 0.10 inches. The blanks are cut to an average length of 20.0 inches. The length of the blanks cut are normally distributed with a standard deviation of 0.10 inches. Create and plot a histogram with CDF. The specification for the blanks is to have volume between 46 and 49 in3. With the current process, what fraction of the blanks are meeting the specification? What changes to the process or equipment would you recommend for 99.0% of the blanks to be within the specification? Consider at least 200 but not more than 1000 parts. Be certain to document the proposed changes on a third worksheet in the workbook.

During january 2018, the following transactions occur: january 1 purchase equipment for $20,600. the company estimates a residual value of $2,600 and a five-year service life. january 4 pay cash on accounts payable, $10,600. january 8 purchase additional inventory on account, $93,900. january 15 receive cash on accounts receivable, $23,100 january 19 pay cash for salaries, $30,900. january 28 pay cash for january utilities, $17,600. january 30 firework sales for january total $231,000. all of these sales are on account. the cost of the units sold is $120,500. the following information is available on january 31, 2018. depreciation on the equipment for the month of january is calculated using the straight-line method. the company estimates future uncollectible accounts. at the end of january, considering the total ending balance of the accounts receivable account as shown on the general ledger tab, $4,100 is now past due (older than 90 days), while the remainder of the balance is current (less than 90 days old). the company estimates that 50% of the past due balance will be uncollectible and only 3% of the current balance will become uncollectible. record the estimated bad debt expense. accrued interest revenue on notes receivable for january. unpaid salaries at the end of january are $33,700. accrued income taxes at the end of january are $10,100