Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As the Merchandise Buyer for Men's suits, you are tasked to revise the merchandise budget plan below for months of May and June 2017.The Great

As the Merchandise Buyer for Men's suits, you are tasked to revise the merchandise budget plan below for months of May and June 2017.The Great Singapore Sales in June is expected to generate 20% sales instead of 12% as originally budgeted.

Analyse and explain the revised figures in the plan.

image text in transcribed

Marketmax - Financial Planning - Worksheet: Men's Tailored Suits - Budget Plan (Business View: 'Merchandise Budget Plan : Global") -OX Worksheet Financial Planning M Plan Edit View Tools Help Skip To A Spring April May June July August September 1. Sales % Distribution to Season 100.00% 21.00% 12.00% 12.00% 19.00% 21.00% 15.00% 2. Monthly Sales $130,000 $27,300 $15,600 $15,600 $24,700 $27,300 $19,500 3. Reduc % Distribution to Season 100.00% 40.00% 14.00% 16.00% 12.00% 10.00% 8.00% 4. Monthly Reductions $16,500 $6,600 $2,310 $2,640 $1,980 $1,650 $1,320 5. BOM Stock to Sales Ratio 4.00 3.60 4.40 4.40 4.00 3.60 4.00 6. BOM Inventory $98,280 $98.280 $68,640 $68.640 $98,800 $98,280 $78,000 7. EOM Inventory $65,600 $68,640 $68,640 $98,800 $98,280 $78,000 $65,600 8. Monthly Additions to Stock $113,820 $4,260 $17,920 $48,400 $26,160 $8,670 $8,420

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

Essentials Of Forensic Accounting

Authors: Michael A Crain, William S Hopwood

2nd Edition

1948306441, 978-1948306447

More Books

Students also viewed these Accounting questions