Accounting 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.