Reimold_bma05_E9_204_start - Excel (Unlig AutoSave OR File Home 9 Insert : Page Layout Formulas Data Review View Help Search Calibri = = D . - 12 - - A A .A. Wrap Text Merge & Center - General $ -% 98- Paste BIU. Clipboard Font Alignment Number A3 F G H 1 The Master Budget 2 Production Budget Hoffman Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each 4 quarter of the upcoming year are as follows: 1st quarter 2nd quarter 3rd quarter 4th quarter Total sales revenue Number of jars sold $181,000 152,500 $219,000 181,500 $255,000 213,000 $199,000 160,500 Hoffman anticipates selling the following in the first quarter of the year following the year given in the 12 preceding table: Sales in units (jars) 223,000 Sales revenue $260,000 16 Hoffman has a policy that the ending inventory of Jars must be: 30% of the following quarter's sales AutoSave E E = Reimold_bma05_E9_20A File H ome Insert Page Layout Formulas Data Review View Help t Calibri - 12 AA BIU - D-A.A. == > 3 Wrap Text Merge & Center - Custom $ 9 Paste Clipboard Font Alignment 38 x fx (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Use cell references from 1 prior calculations, if applicable.) m in Hoffman Foods Production Budget For the upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 181,000 219,000 255,000 199,000 Year 854,000 7 Unit sales Plus: Desired ending inventory 9 Total needed 10 Less: Beginning inventory 1 Number of units to produce INSTRUCTIONS ENTERANSWERS Type here to search