Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

find the gross margin $ of this year plan find the gross margin % of this year formula find the turnover TY plan formula find


 find the gross margin $ of this year plan 

 find the gross margin % of this year formula 

find the turnover TY plan formula

find the sell through % TY plan formula

 find the weeks of supply TY plan formmula


image

Gross Margin ($) TY Plan $ 177,025 $ 240,346 $ Gross Margin ($) LY Actual $ 177,025 $ +/-% Chg. $ $ 240,346 $ $ 244,248 $ 244,248 $ $ 350,541 $ 577,852 $ 437,817 $ 2,027,829 350,541 $ $ 543,645 $ 0 $ 437,817 $ 1,993,622 $ 0.02 Gross Margin (%) TY Plan 56.9% 58.0% 54.4% 56.4% 55.8% 57.6% 56.5% Gross Margin (%) LY Actual 56.9% 58.0% 54.4% 56.4% 60.5% 57.6% 57.7% Turnover TY Plan 0.40 0.44 0.37 0.32 0.49 0.45 2.47 Turnover LY Actual 0.38 0.40 0.33 0.35 0.46 0.41 2.33 Sell Through % TY Plan 26.3% 29.1% 23.9% 20.0% 37.7% 31.0% 70.1% Sell Through % LY Actual 24.6% 27.0% 21.7% 23.9% 32.1% 30.0% 68.9% Weeks of Supply TY Plan 9.9 9.1 10.9 12.6 8.1 9.0 Weeks of Supply LY Actual 10.6 12.5 12.2 11.6 10.8 9.7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing A Risk Based Approach to Conducting a Quality Audit

Authors: Karla Johnstone, Audrey Gramling, Larry E. Rittenberg

10th edition

1305080572, 978-1305465664, 1305465660, 978-1305080577

More Books

Students also viewed these Finance questions

Question

1. What is business law?

Answered: 1 week ago

Question

Question 2 For an n x n matrix A = form) via (aij)

Answered: 1 week ago