60.1K

Verified Solution

Link Copied!

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.

& Cut Book Antiqua 12 A E 207 v 9 Wrap Text v General Normal Bad Autoun A . [ Copy Paste 10:55 AM Format Uv MVA Merge & Center v $ ~ % " 08 0 Conditional Format Good Neutral Insert Delete Format DISK NOT EJECTED PROPERLY Formatting as Table Eject "STAFFNEWS2" before disconnecting or turning it off. Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? J11 Jx B C D E F G H K M N o P Q Month #1 Month #2 Month #3 Month #4 Projected Sales $ $65,000.00 $97,500.00 $130,000.00 $110,500.00 3 Projected Quantity (Calculated) 10,000 15,000 20,000 17,000 5 Beginning FG Inventory Units 1000 1500 2000 1700 6 Desired FG Inventory Units 1,500 2,000 1,700 8 Items Produced 10,500 15,500 19,700 9 10 11 Variable Manufacturing Overhead $1,680.00 $2,480.00 $3,152.00 Supplies $210.00 $310.00 $394.00 Inspection $1,050.00 $1,550.00 $1,970.00 Maintenance & Repair $315.00 $465.00 $591.00 15 Utilities $105.00 $155.00 $197.00 Fixed Overhead $1,100.00 $1,100.00 $1,100.00 $1,100.00 18 19 20 DMaterials DLabor Overhead S&A Budgeted Income Statement + Ready 125%

Answer & Explanation Solved by verified expert

See Answer