AdvertisingBudgetQuestion_SEOKGYUHAN

AdvertisingBudgetQuestion_SEOKGYUHAN - Save your completed...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Advertising Budget Model Q1 Current Price $40.00 Cost of Goods per unit $25.00 Quantity Sold 3000.00 9.00% 15.00% 8.50% Unit Solds 3000 Total Revenue $120,000.00 Total Cost of Goods $75,000.00 Total Seasonal Advertising $10,800.00 Total Overhead $10,200.00 Total Costs $96,000.00 Profit $24,000.00 Profit Margin 20.00% Instructions Complete the Table Above for Rows 11 to 19, Profit Margin is calculates as the Profit Divided by the Revenue Copy the Completed Sheet called Actual to a Second Sheet Called Ideal Use the Goal Seek , What If Data Analysis to Force the Profit Margin to 20% for Each Qu
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Save your completed file and email it. Seasonal Advertising (Percentage of Sales) Overhead rate (Percentage of Sales) Q2 Q3 Q4 4300.00 3200.00 4800.00 11.00% 8.00% 12.00% 6.50% 9.50% 5.50% 4300 3200 4800 $172,000.00 $128,000.00 $192,000.00 $107,500.00 $80,000.00 $120,000.00 $18,920.00 $10,240.00 $23,040.00 $11,180.00 $12,160.00 $10,560.00 $137,600.00 $102,400.00 $153,600.00 $34,400.00 $25,600.00 $38,400.00 20.00% 20.00% 20.00% uarter by Making Adjustments in the Overhead Rate...
View Full Document

Page1 / 2

AdvertisingBudgetQuestion_SEOKGYUHAN - Save your completed...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online