To create a production budget qith desired ending inventory of 10% of next QTRS for next year Q4.

TAB 7 - Label Tab 7 Production Budget (10 Points) Copy your Production Budget to Tab 7. Using the budgeted sales from your previous sales budget (Tab 6) create a production budget. Your desired ending inventory is 10% of the next QTRS sales. In Q4 your have reach max production capacity which continues into next year. TAB 8 - Label Tab 8 Flexible Budget Q1 Q2 Sales (Units) 447 894 Selling price per unit $ 50.00 $ 50.00 $ Total sales $22,350.00 $ 44,700.00 Cash Collected $20,115.00 $ 42,465.00 $ The formulas used are given in the image. Happy 01 3 Sales (Units) 4 Selling price per unit 5 Total sales 6 Cash Collected 7 447 50 =B3 B4 =90% B5 Q2 =B32 50 =C3 C4 =(10%*B5)+(90%*C5) LAMA Yea 6 Q3 Q4 1788 3576 0.00 $ 50.00 $ 50.00 0.00 $ 89,400.00 $1,78,800.00 $ 5.00 $ 84,930.00 $1,69,860.00 $ 3, 3, Happy learning :) D E Q3 Q4 Ye: =SUM(B3:E3) =D3*2 =C3*2 50 =D3*D4 1=(10%*C5)+(90%*D5) 50 =E3*E4 =(10%*D5)+(90%*E5) =SUM(B5:E5) =SUM(B6:E6) C5) Year total 6705 Q3 Q4 1788 3576 00 $ 50.00 $ 50.00 .00 $ 89,400.00 $1,78,800.00 $ .00 $ 84,930.00 $1,69,860.00 $ 3,35,250.00 3,17,370.00 appy learning :) D E F Year total =SUM(B3:E3) Q3 =C32 50 =D3 D4 =(10%*C5)+(90%*D5) Q4 =D32 50 =E3 E4 =(10%*D5)+(90%*E5) =SUM(B5:E5) =SUM(B6:06)