You are to prepare a P&L budget for the 2nd quarter of 2019 based on data from the previous 15 months. Your budget should include only cell references and formulas based on the budgeted data you will fill in for April through June. The budgeted data you will fill in for April through June should also use cell references and formulas based on your regression models which should be labeled as other sheets within your workbook.

-Management likes to keep an inventory equal to 15% of next month's estimated production. Build this into your budget to correctly calculate cost of goods sold. You can assume the company followed this pattern when purchasing March 2018 production needs. The average cost of each unit in ending inventory at March 31, 2019 is $51.29 (you should be able to calculate this number from the data). You will need to calculate the average cost of each unit in ending inventory for April through June based on each month's forecasted production costs.

I have to do the last part, the income statement. it can only be cell references. So I am not sure where he gets the $51.29 from the instructions.

Month Overhead Machine Hours #ofSetups Hours units S649.589S 2,287,650 1,258,233 $760,943 S 5,001,020 S1,440.725 $1,158,527 $5,835,425 S1,892,152 5 $1,100,496 $ 4,862,457 $1,690,450 0 19 BUDGETED: 2 S967,084 S 7,131,079 $1,883,292 5 2 8 28 Less cost of goods sold 29 Beginning inventory 0 Add: Cost of goods manufactured 1 Less: ending inventory 2 Cost of goods sold 3 Gross Margin 4 Less: SG&A Expense Income