Question 1. The table below is a local retailer's six-month plan for the spring and summer season. Please find out the answers from A to I listed in the table and label your homework by Question 1 A to I and show works Last Season's Sales in $1,500 thousands IMU% 65% This season: %change +8.40% This season sales $A? Reduction plan 14% This season Red. $B? This Season Gross Sales $C? Spring Feb Mar Apr May June July total Mnthly % plan 15.00% 20.00% 19.00% 13.00% 14.00% 19.00% Sales $ Plan $243.90 $325.20 $308.94 D? $227.64 $308.94 Red % Plan 1.64% 2.08% 2.64% 1.96% 2.40% 3.28% Red $ Plan $26.67 $33.82 $42.93 E? $39.02 $53.33 EOM $ Plan $1,186.98 $1,217.22 $1105.52 F? $973.16 $1,030.65 S-S Ratio Plan 4.44 3.65 3.94 5.23 4.37 3.15 BOM $ Plan $1,082.92 $1,186.98 $1,217.22 G1? G2? $973.16 PI purchase $ $374.63 $389.26 $240.16 $132.52 H? $419.76 OTB cost $131.12 $136.24 $84.60 $46.38 1? $146.92 100.00%
Question 1. The table below is a local retailer's six-month plan for the spring and summer season. Please find out the answers from A to I listed in the table and label your homework by Question 1 A to I and show works Last Season's Sales in $1,500 thousands IMU% 65% This season: %change +8.40% This season sales $A? Reduction plan 14% This season Red. $B? This Season Gross Sales $C? Spring Feb Mar Apr May June July total Mnthly % plan 15.00% 20.00% 19.00% 13.00% 14.00% 19.00% Sales $ Plan $243.90 $325.20 $308.94 D? $227.64 $308.94 Red % Plan 1.64% 2.08% 2.64% 1.96% 2.40% 3.28% Red $ Plan $26.67 $33.82 $42.93 E? $39.02 $53.33 EOM $ Plan $1,186.98 $1,217.22 $1105.52 F? $973.16 $1,030.65 S-S Ratio Plan 4.44 3.65 3.94 5.23 4.37 3.15 BOM $ Plan $1,082.92 $1,186.98 $1,217.22 G1? G2? $973.16 PI purchase $ $374.63 $389.26 $240.16 $132.52 H? $419.76 OTB cost $131.12 $136.24 $84.60 $46.38 1? $146.92 100.00%
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 2CMA
Related questions
Question
Transcribed Image Text:Question 1. The table below is a local retailer's six-month plan for the spring and summer season. Please find out
the answers from A to I listed in the table and label your homework by Question 1 A to I and show works
Last Season's
Sales
in
$1,500
thousands
IMU%
65%
This season: %change
+8.40%
This season sales $A?
Reduction plan
14%
This season Red. $B?
This Season Gross
Sales $C?
Spring
Feb
Mar
Apr
May
June
July
total
Mnthly % plan
15.00%
20.00%
19.00%
13.00%
14.00%
19.00%
Sales $ Plan
$243.90
$325.20
$308.94
D?
$227.64
$308.94
Red % Plan
1.64%
2.08%
2.64%
1.96%
2.40%
3.28%
Red $ Plan
$26.67
$33.82
$42.93
E?
$39.02
$53.33
EOM $ Plan
$1,186.98
$1,217.22
$1105.52
F?
$973.16 $1,030.65
S-S Ratio Plan
4.44
3.65
3.94
5.23
4.37
3.15
BOM $ Plan
$1,082.92
$1,186.98 $1,217.22
G1?
G2?
$973.16
PI purchase $
$374.63
$389.26 $240.16
$132.52
H?
$419.76
OTB cost
$131.12
$136.24 $84.60
$46.38
1?
$146.92
100.00%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub