Given the six-month merchandise budget below, answer questions #1-4. When comple
ID: 2823061 • Letter: G
Question
Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents)
4. What is the “Total $ Planned Purchases at Cost” figure?
Last Year’s Total Sales = $100,000
Planned % Sales Increase = 5%
Planned % Reductions = 14%
Planned EOM for Period = $25,000
Planned IMU% for Period = 53%
Six-Month Merchandise Budget
Spring/Summer
February
March
April
May
June
July
Totals
Planned Sales
Planned Sales %
10%
25%
20%
20%
15%
10%
100%
Planned BOM Stock
____________
Planned S/S Ratio
2.70
2.30
1.96
1.85
1.87
2.20
____________
Planned EOM Stock
____________
Planned Reductions
Planned Reductions %
10%
15%
20%
22%
18%
15%
100%
Planned Purchases @ Retail
Planned Purchases @ Cost
$116,350
$52,640
$73,085
$54,684.50
Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents)
4. What is the “Total $ Planned Purchases at Cost” figure?
Explanation / Answer
The answer
Planned Purchase represents the merchandise that is to be purchased during any given period.
The formula for Planned Purchase =Planned Sales+Planned Reductions+Planned EOM -Planned BOM
The answer is a as uploaded in the JPEG file. Mar Apr May jun july Total 25% 20% 20% 15% 10% 100% $26,250 $21,000 $21,000 $15,750 $10,500 $105,000 47% 47% 47% 47% 47% $49,350 $49,350 $49,350 $49,350 $49,350 $296,100 $11,290.17 $11,290.17 $11,290.17 $11,290.17 $11,290.17 $67,741 2.3 1.96 1.85 1.87 2.2 $60,375.00 $41,160.00 $38,850.00 $29,452.50 $23,100.00 $221,287.50 $26,515.17 $40,480.17 $42,790.17 $46,937.67 $48,040.17 $247,553.50 $116,350.15
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.