Please fill in month 4 stats using the information below:

These sales are based on selling one product with a selling price of $6.50

Production Budget based on Units (not dollars). ? Desired Finished Goods Ending Inventory each month is 10% of the next month's projected sales. (Use the Finished Goods Ending Inventory amount for the previous year for the Beginning Finished Goods Inventory to start this year. The Finished Goods Inventory for the previous month is 1000 units.)

Direct Materials Purchase Budget ? Each unit produced requires 10# (pounds) of direct materials at a cost of $0.08 per pound.

Direct Labor Budget ? Direct Labor Costs are $15/per hour ? Each unit requires 5 minutes of labor

? Variable Overhead Expenses are: o Supplies ($.02 per unit) o Inspection ($.10 per unit) o Maintenance and Repair ($.03 per unit) o Utilities ($.01 per unit) ? Fixed Overhead Expenses are $1,100 monthly.

? Variable Selling & Administrative Expenses are: o Sales Commissions ($.03 per unit) o Delivery ($.01 per unit) o Office Support ($.02 per unit) ? Fixed Selling & Administrative Expenses are $2,500 monthly.

Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments & Cut Book Antiqua 12 A 207 ag Wrap Text v General Normal Bad AutoSum v Ap . [ Copy Fill v Paste Format B IUV MVA v Merge & Center v $ ~ % 9 Conditional Format Good Neutral Insert Delete Format Sort & Find & Analyze Formatting as lable Clear v Sensitivity Filter Select Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No 25 X fx A B C D E F G H K Month #1 Month #2 Month #3 Month #4 ojected Sales $ $65,000.00 $97,500.00 $130,000.00 $110,500.00 ojected Quantity (Calculated) 10,000 15,000 20,000 eginning FG Inventory Units 1000 1500 2000 esired FG Inventory Units 1,500 2,000 1,700 ems Produced 10,500 15,500 19,700 0 laterial Quantity Needed (Total #) 105,000 155,000 197,000 2 laterial Cost $ $8,400.00 $12,400.00 $15,760.00