Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How can I calculate the Average Stock based on this table? LY Actual Plan Seasonal Sales $ GA 2,011.2 $ 2,095.7 Sales inc./dec% 4.2% Alteration

How can I calculate the Average Stock based on this table?
image text in transcribed
image text in transcribed
LY Actual Plan Seasonal Sales $ GA 2,011.2 $ 2,095.7 Sales inc./dec% 4.2% Alteration and Workroom Costs 2.8% 3.0% Cash Discount % 3.5% 4.0% Calculate - use 3.25 for Basic Stock Method Plan Seasonal Stock Turnover 2.1% 2.0% Shortage % Average Stock Average Monthly Sales Markdown % Employee Discounts% Initial MU% GMROI 3 Profit GM% SEOM for July 6 $335.2 18.8% 4.5% 58.6% $349.3 21.0% 4.0% 60.6% 10.0% 48.8% $747.7 14.0% 51.0% $755.0 Feb Mar Apr May June July Sales 285.5$ 311.3$ 298.7 $ 325.5$ 444.5$ 345.7 BOM LY (actual) LY (actual) LY (actual) 723.5 1021.4 822.1 845.7 1138.7 897.7 Reduction% 12.5% 15.0% 14.5% 17.0% 23.0% 18.0% LY Actual Plan Seasonal Sales $ GA 2,011.2 $ 2,095.7 Sales inc./dec% 4.2% Alteration and Workroom Costs 2.8% 3.0% Cash Discount % 3.5% 4.0% Calculate - use 3.25 for Basic Stock Method Plan Seasonal Stock Turnover 2.1% 2.0% Shortage % Average Stock Average Monthly Sales Markdown % Employee Discounts% Initial MU% GMROI 3 Profit GM% SEOM for July 6 $335.2 18.8% 4.5% 58.6% $349.3 21.0% 4.0% 60.6% 10.0% 48.8% $747.7 14.0% 51.0% $755.0 Feb Mar Apr May June July Sales 285.5$ 311.3$ 298.7 $ 325.5$ 444.5$ 345.7 BOM LY (actual) LY (actual) LY (actual) 723.5 1021.4 822.1 845.7 1138.7 897.7 Reduction% 12.5% 15.0% 14.5% 17.0% 23.0% 18.0%

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

How To Avoid IRS Audits

Authors: Victor S. Sy, CPA, MBA, Allana Santos, Roger Oriel, Louie Gajardo, Malou Aguilar Bledsoe, RJ Oriel, Mark Xavier Bautista, Kenno Samulde, Morton D Rosenthal Esq.

1st Edition

1530746477, 978-1530746477

More Books

Students also viewed these Accounting questions