Question: do not understand what is going on. Will you please help me. Master Budget (P9-57A) Student Name: SALES BUDGET: Jan Feb Mar Quarter Feb Mar

do not understand what is going on. Will you please help me.

do not understand what is going on. Will you please help me.

Master Budget (P9-57A) Student Name: SALES BUDGET: Jan Feb Mar Quarter Feb Mar Quarter Jan Feb Mar Quarter Jan Feb Mar Quarter Jan Feb Mar Quarter Jan Feb Mar Quarter Budgeted unit sales Selling price per unit Total Sales SCHEDULE OF EXPECTED CASH COLLECTIONS: Jan Cash sales Credit sales Total Cash Collections PRODUCTION BUDGET: Budgeted unit sales Add desired ending inventory Total needs Less beginning inventory Units to produce DIRECT MATERIALS BUDGET: Units to be produced Multiply by: Quantity of DM needed per unit Quantity of DM needed for production Plus: Desired ending inventory of DM Total quantity of DM needed Less beginning inventory of DM Quantity of DM to purchase Multiply by: Cost per pound Total cost of DM purchases CASH PAYMENTS FOR DM PURCHASES: Accounts payable Januray purchases February purchases March purchases Total cash payments CASH PAYMENTS FOR DIRECT LABOR: Direct labor CASH PAYMENTS FOR MANUFACTURING OVERHEAD Jan Variable manufacturing overhead costs Rent (fixed) Other MOH (fixed) Total cash payments CASH PAYMENTS FOR OPERATING EXPENSES Jan Variable operating expenses Fixed operating expenses Total cash payments Feb Mar Quarter Feb Mar Quarter Mar Quarter CASH BUDGET FOR THE THREE MONTHS ENDING March 31 Jan Feb Cash balance, beginning Add collections from customers Total cash available Less cash payments DM purchases Direct labor MOH costs Operating Expenses Tax Payment Equipment purchases Total Disbursements Ending cash balance before financing Financing: Borrowings Repayments (enter as a neg. number) Interest payments (enter as a neg. number) Total financing Cash balance, ending - BUDGETED MANUFACTURING COST PER UNIT Direct materials cost per unit Direct labor cost per unit Variable manufacturing costs per unit Fixed manufacturing overhead per unit Cost of manufacturing each unit 0.80 - - Martin Manufacturing BUDGETED INCOME STATEMENT FOR THE THREE MONTHS ENDED March 31 Sales Less COGS: Gross profit Less expenses: Operating Expenses Depreciation Operating Income Interest Expense Income tax expense Net income GRADING IS SHOWN TO THE RIGHT---> GRADING: CASH COLLECTIONS BUDGET: Correct/Incorre Points Cell Ref ct Awarded D14 INCORRECT 0 D15 INCORRECT 0 D16 INCORRECT 0 E14 INCORRECT 0 E15 INCORRECT 0 E16 INCORRECT 0 F14 INCORRECT 0 F15 INCORRECT 0 F16 INCORRECT 0 G16 INCORRECT 0 TOTAL 0 Apr Apr PRODUCTION BUDGET: D23 INCORRECT D24 INCORRECT D25 INCORRECT E23 INCORRECT E24 INCORRECT E25 INCORRECT F23 INCORRECT F24 INCORRECT F25 INCORRECT G25 INCORRECT TOTAL 0 0 0 0 0 0 0 0 0 0 0 DM BUDGET: D33 INCORRECT D35 INCORRECT D37 INCORRECT E33 INCORRECT E35 INCORRECT E37 INCORRECT F33 INCORRECT F35 INCORRECT F37 INCORRECT G37 INCORRECT TOTAL 0 0 0 0 0 0 0 0 0 0 0 CASH PAYMENT FOR DM PURCHASES D46 INCORRECT 0 E46 INCORRECT 0 F46 INCORRECT 0 G46 INCORRECT 0 TOTAL 0 CASH PAYMENT FOR DIRECT LABOR D51 INCORRECT 0 E51 INCORRECT 0 F51 INCORRECT 0 G51 INCORRECT 0 TOTAL 0 CASH PAYMENT FOR MOH D60 INCORRECT E60 INCORRECT F60 INCORRECT G60 INCORRECT TOTAL 0 0 0 0 0 CASH PAYMENT FOR OPERATING EXPENSES D67 INCORRECT 0 E67 INCORRECT 0 F67 INCORRECT 0 G67 INCORRECT 0 TOTAL 0 CASH BUDGET D75 INCORRECT D84 INCORRECT D91 INCORRECT D93 INCORRECT E75 INCORRECT E84 INCORRECT E91 INCORRECT E93 INCORRECT F75 INCORRECT F84 INCORRECT F91 INCORRECT F93 INCORRECT G75 INCORRECT G84 INCORRECT G91 INCORRECT G93 INCORRECT TOTAL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 MANUFACTURING COST PER UNIT D98 INCORRECT 0 D99 INCORRECT 0 D100 INCORRECT 0 D101 CORRECT 2 D102 INCORRECT 0 TOTAL 2 INCOME STATEMENT F108 INCORRECT F109 INCORRECT F110 INCORRECT F112 F113 F114 F115 F116 F117 INCORRECT INCORRECT INCORRECT INCORRECT INCORRECT INCORRECT TOTAL GRAND T 0 0 0 0 0 0 0 0 0 0 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!