Widgets R US Corp. Master Budget 2019 Sales Budget (Part 1) Data Input Q1 Q2 Q3 04 Year Sales Price $380.00 65 000 $380.00 $24,700,000.00 60,000 $380.00 $22,800,000.00 75,000 $380.00 $28,500,000.00 80 000 $380.00 $30,400,000.00 280.000 $1,520.00 $105,400,000.00 Unit Sales Q1 Q2 93 04 65,000 60,000 75,000 80,000 Unit Materials Cost $65.00 Sales in Units Selling price/unit 1 Gross Revenue Cash Collections: Collections of Accounts Receivable 4 75% Current Quarter's Sales $ 25% Previous Quarter's Sales Total Cash Collections $18,525,000.00 $3,250,000.00 $21,775,000.00 $17,100,000.00 $6,175,000.00 $23,275,000.00 $21,375,000.00 $5,700,000.00 $27,075,000.00 $22,800,000.00 $7,125,000.00 $29,925,000.00 $79,800,000.00 $22,250,000.00 $102,050,000.00 01 2020 sales production: 70,000 80,000 Direct Labor Rate $21.00 Per Hour Otrly Dividend $300,000.00 Variable Overhead $6.00 /Dir. Labor Hr. 2 Production Budget (Part 2) U Variables R AED $8.00 /Unit Sold 01 Q2 03 04 1 2 Year 65,000 60,000 75,000 80,000 280,000 42,750 3 Budgeted Unit Sales # Add: Desired End.inv. 5 of finished goods Total units needed Less: Beg, Inv. Budgeted production 9,000 74,000 13.000 11,250 71,250 9,000 62,250 12,000 87,000 11,250 75,750 10.500 90,500 12,000 78,500 322,750 45,250 277,500 61.000 A B G H D E Direct Materials Purchases Budget (Part 3) Q1 Q2 Q3 04 Year 36,000 28,800 Budgeted production Raw materials needed/Unit Total needed for production Add: Desired raw materials ending inventory Total Direct Materials needed Less: Beginning inventory Total D.M. Purchased Unit materials cost Total Direct Materials Cost Cash Disbursements for D.M. 85% Current Quarter's Purchases 15% Previous Quarter's Purchases Total Cash Disbursements for D.M. $1,500,000.00 Direct Labor Budget (Part 4) Q1 Q2 Q3 Q4 Year 2.50 2.50 2.50 2.50 2.50 Budgeted Production Direct Labor hours per unit Total Direct Labor Hours Needed Hourly Wage Rate Budgeted Direct Labor Costs Factory Overhead Budget (Part 5) Q1 Q2 Q3 Q4 Year Budgeted Direct Labor Hours: Variable Overhead Rate per Direct Labor Hour Total Variable Mfg. Overhead Fixed Mfg. Overhead: Depreciation Other Fixed Overhead Expenses Total Fixed Overhead Total Mfg. Overhead Less: non-cash exp (depreciation) Cash Disbursements for Factory Overhead Selling and Administration Expense Budget (Part 6) Q1 Q2 Q3 Q4 Year Budgeted Units Sold Variable Selling and Administration Expenses per Unit Total Variable S & A Expenses Fixed Selling and Administration Exp. Depreciation Other Fixed S & A Expense Total Fixed Selling and Admin. Exp. Total Selling and Administration Exp. Less: non-cash exp (depreciation) Cash Disbursements for Selling and Administration Expenses Factory Overhead Budget (Part 5) Q1 Q2 Q3 Q4 Year Budgeted Direct Labor Hours: Variable Overhead Rate per Direct Labor Hour Total Variable Mfg. Overhead Fixed Mfg. Overhead: Depreciation Other Fixed Overhead Expenses Total Fixed Overhead Total Mfg. Overhead Less: non-cash exp (depreciation) Cash Disbursements for Factory Overhead Selling and Administration Expense Budget (Part 6) Q1 Q2 Q3 Q4 Year Budgeted Units Sold Variable Selling and Administration Expenses per Unit Total Variable S & A Expenses Fixed Selling and Administration Exp. Depreciation Other Fixed S & A Expense Total Fixed Selling and Admin. Exp. Total Selling and Administration Exp. Less: non-cash exp (depreciation) Cash Disbursements for Selling and Administration Expenses 2:10 Quill 52% Read Only - You can't save changes to this file. fx L M N 0 P 92 93 94 95 96 97 98 Schedule 1 99 100 101 Cost Element Direct Materials Direct Labor M.O.H.* Unit Cost Quantity 3.00 2.50 1.00 Total 0.00 0.00 0.00000 102 103 104 105 106 Mfg. Cost per unit $0.00000 107 108 *Mfg. overhead Units Produced 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 II 128 Income taxes for the year are paid in the 4th Master Budget Additional Info. +
