Assignment:
Use the following Template to complete your assignment:
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.
Template:
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
Coopie Awards
Sales Budget
For the current Year
Region Sales Volume Selling Price Total Sales
Western
Central
Eastern
Total Units