Please do spreadsheet Develop a merchandise plan on the basis of the information that follows Sales for the six month spring summer season have been planned to total $650,000 Markdowns for the total season are to be 22 0 of planned sales, and seasons turnover should be 1 9 BOM inventory values are to be planned by the basic stock method In this problem, ending inventory will be the same as the average inventory (A merchandise plan form is provided to complete the problem ) (a) Total sales for the season are $650,000 Determine sales for each month (b) Calculate total $ markdowns and allocate markdowns to each month on the basis of the percentages given (c) Using the basic stock method, calculate BOM inventory values for each month (d) Enter the EOM inventory values on the form July's ending inventory has been given as the average inventory (e) Calculate planned purchases at retail (f) Calculate initial markup percent needed, given the following information

The Answer is in the image, click to view ...

Question: Please do spreadsheet!! Develop a merchandise plan on the basis of the information that follows. Sales for the six-month spring summer season have been planned

Please do spreadsheet!!

Develop a merchandise plan on the basis of the information that follows. Sales for the six-month spring summer season have been planned to total $650,000. Markdowns for the total season are to be 22.0% of planned sales, and seasons turnover should be 1.9. BOM inventory values are to be planned by the basic stock method. In this problem, ending inventory will be the same as the average inventory. (A merchandise plan form is provided to complete the problem.)

Please do spreadsheet!! Develop a merchandise plan on the basis of the

(a) Total sales for the season are $650,000. Determine sales for each month. (b) Calculate total $ markdowns and allocate markdowns to each month on the basis of the percentages given. (c) Using the basic stock method, calculate BOM inventory values for each month. (d) Enter the EOM inventory values on the form. July's ending inventory has been given as the average inventory. (e) Calculate planned purchases at retail. (f) Calculate initial markup percent needed, given the following information

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Through Excel Forms that are used for six-month merchandise plans vary from retailer to retailer. Less formal and less detailed plans may be used by small retail organizations, while larger...

gures. Practice Problems Exercise 8.5 1. Develop a merchandise plan on the basis of the information that follows. Sales for the six-month spring- summer season have been planned to total $650,000....

Develop a merchandise plan on the basis of the information that follows. Sales for the six - month spring - summer season have been planned to total $ 6 5 0 , 0 0 0 . Markdowns for the total season...

Practice Problems * Exercise 8.5 Develop a merchandise plan on the basis of the information that follows. Sales for the six-month springsummer season have been planned to total $650,000 . Markdowns fo

please help me fill this out i dont know what im doing do not worry about the buyer or anything 1. Prepare a six-month merchandise plan based on the information below. PHOSIS are expected to be the...

please help me fill this out i dont know what to do 1. Prepare a six-month merchandise plan based on the information below. PHOSIS are expected to be the same as last year. Month LY Sales February...

pleass help idk what to do SIX MONTH MERCHANDISE PLAN Department Name: Last Year Plan Actual Department Number: Merchandise Manager: SALES CMU% MD% GM% AVG STOCK TURNOVER Buyer: Period: February...

the first 2 photos include the problem, the next 2 include the six month plan with the yellow places where i need to fill things out, and the last 2 are formulas incase you need them. please answer...

CASE STUDY 4 FORMULATING A Six-MONTH PLAN When the buyer for the activewear department started to develop the merchandise plan for the Spring season, she reviewed the six-month plan in Figure 35. The...

When the buyer for the activewear department started to develop the merchandise plan for the Spring season, they reviewed the six-month on the next sheet. The numbers that were achieved represent the...

3. Same as Problem 2, except A and B form an LLC rather than a general partner- ship and there is no deficit restoration obligation. nership interest. Assume there is a state law assumption of the...

Sooner Company. uses a job-order costing system. During May, the following costs appeared in the Work in Process Inventory account: Beginning balance Direct material used $ 30,000 90, 000 75, 000...

Willie is currently age 4 8 and is the owner of Willie s Wild West Salon, a wildly successful saloon - themed hair salon with twenty locations throughout the state of Texas. Willie doesn t plan to...

Employee works as a forklift driver in a warehousing operation. While adjusting the forks on his forklift, Employee drops a fork on his toes. X - rays reveal a small fracture to his smallest toe. The...