Accounting 141 Budgeting for a Manufacturer - coopie awards

Given financial information, prepare Coopie Awards' master budget. Notice, you will prepare a different budget on each tab of the spreadsheet. The last tab in the spreadsheet you will complete for the discussion forum.

Coopie Awards produces brass plaques. They operates in 3 regions of the country. The western region sales manager estimates sales of 20,000 plaques for the region. The central regional manager estimates sales of 10,000 plaques for the region and the eastern sales manager estimates slaes of 15,000 plaques for the region. Each plaque sells for $35.
Requirement: Prepare the sales budget for Coopie Awards

production budget

Direct materials budget

Direct labor cost budget

cost of goods sold budget

selling and admin expense budget

income statement

actual results

Coopie Awards sold 43,000 brass plaques for the current year with the following results. In the discussion forum comment on Coopie Awards results.