Question

In: Finance

Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round...

Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents)

4. What is the “Total $ Planned Purchases at Cost” figure?

Last Year’s Total Sales = $100,000

Planned % Sales Increase = 5%

Planned % Reductions = 14%

Planned EOM for Period = $25,000

Planned IMU% for Period = 53%

Six-Month Merchandise Budget

Spring/Summer

February

March

April

May

June

July

Totals

Planned Sales

Planned Sales %    

10%

25%

20%

20%

15%

10%

100%  

Planned BOM Stock

____________

Planned S/S Ratio

2.70

2.30

1.96

1.85

1.87

2.20

____________

Planned EOM Stock

____________

Planned Reductions

Planned Reductions %

10%

15%

20%

22%

18%

15%

100%  

Planned Purchases @ Retail

Planned Purchases @ Cost

A.

$116,350

B.

$52,640

C.

$73,085

D.

$54,684.50

Solutions

Expert Solution

The answer

Planned Purchase represents the merchandise that is to be purchased during any given period.

The formula for Planned Purchase =Planned Sales+Planned Reductions+Planned EOM -Planned BOM

The answer is a as uploaded in the JPEG file.
Mar Apr May jun july Total
25% 20% 20% 15% 10% 100%
$26,250 $21,000 $21,000 $15,750 $10,500 $105,000
47% 47% 47% 47% 47%
$49,350 $49,350 $49,350 $49,350 $49,350 $296,100
$11,290.17 $11,290.17 $11,290.17 $11,290.17 $11,290.17 $67,741
2.3 1.96 1.85 1.87 2.2
$60,375.00 $41,160.00 $38,850.00 $29,452.50 $23,100.00 $221,287.50
$26,515.17 $40,480.17 $42,790.17 $46,937.67 $48,040.17 $247,553.50
$116,350.15

                                               


Related Solutions

Given the six-month merchandise budget below, answer questions #5-8.  When completing the budget, do not round to...
Given the six-month merchandise budget below, answer questions #5-8.  When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents). 7. What is the “Total $ Planned Purchases at Retail” figure? Last Year’s Total Sales = $790,000 Planned % Sales Increase = 6% Planned % Reductions = 18% Planned EOM for Period = $196,500 Planned IMU%= 55%                                                                 Six-Month Merchandise Budget Fall/Winter August September October November December January Totals Planned Sales Planned...
WEEK 4 DISCUSSION #3 ANSWER THE FOLLOWING QUESTIONS BELOW: 1: Do you need to identify and...
WEEK 4 DISCUSSION #3 ANSWER THE FOLLOWING QUESTIONS BELOW: 1: Do you need to identify and manage every risk to an organization or are there risks that don’t matter? Explain why or why not and provide cases for each. 2: Read “Envisioning Risk – A Systematic Framework for Risk Visualization in Risk Management and Communication Why or why not it is important to be able to visualize risk? How can it help an organization understand risk?
As a buyer, consider when making decisions on preparing a six-month merchandise plan? Describe three sources.
As a buyer, consider when making decisions on preparing a six-month merchandise plan? Describe three sources.
Use the transactions below to answer the following questions. Round to the nearest cent for per...
Use the transactions below to answer the following questions. Round to the nearest cent for per unit cost and the nearest dollar for the totals for COGS, Ending Inventory and Gross Profit. Date Quantity Unit Cost Sale Price Mar 1 Beginning Inventory 30 $30 Mar 4 Purchase 40 $28 Mar 8 Sale 35 $54 Mar 15 Purchase 50 $26 Mar 20 Sale 42 $55 Using the LIFO Method for inventory costing calculate the following amounts for the month of March....
Please answer the six questions. Question 1 Monopolistic competition occurs when _____ firms are competing in...
Please answer the six questions. Question 1 Monopolistic competition occurs when _____ firms are competing in a market to sell _____ products. Group of answer choices many; identical many; similar but differentiated few; similar but differentiated few; identical Question 2 A firm's variable costs _____ depending on the level of production, and typically include _____. Group of answer choices do not change; labor and raw materials change; labor and raw materials stay constant; salaries and insurance vary; advertising and rent...
Read the passage given below, and answer the questions given at the end. Each answer must...
Read the passage given below, and answer the questions given at the end. Each answer must be within the word limit of 50-100 words. Passage: Students are responsible for familiarising themselves with the University Code of Student Conduct, as on enrollment with the University the student has placed themselves under the policies and regulations of the University and all of its duly constituted bodies. Disciplinary authority is exercised through the Student Conduct Committee. The Committee has procedures in place for...
1.) Use the given information below to answer the following questions. a.) A sample of 25...
1.) Use the given information below to answer the following questions. a.) A sample of 25 lightbulbs was taken and it was found that the mean lifetime of a certain bulb for a movie projector is 520 hours with a standard deviation of 50 hours. The standing assumption of the manufacturing company is that the lifetime of this type pf bulb is no more than 500 hours. Assume a normal distribution. Does the data support the company’s claim at a...
Questions 4-8 USE THE FOLLOWING INFORMATION TO ANSWER THE NEXT (5) QUESTIONS: Pitchfork, Inc. sold merchandise...
Questions 4-8 USE THE FOLLOWING INFORMATION TO ANSWER THE NEXT (5) QUESTIONS: Pitchfork, Inc. sold merchandise to Min Corporation on June 1, 2019 and accepted an interest-bearing note with an 8% APR. Min agreed to make annual payments of P&I in the amount of $27,000 per year for 5 years with the first payment being made immediately. The remaining payments are to be remitted each June 1st. Pitchfork’s year-end is December 31st. Min’s normal cost to borrow is 8%. Required:...
QUESTION 1 Study the information given below and answer each of the following questions independently: •          ...
QUESTION 1 Study the information given below and answer each of the following questions independently: •           Calculate the margin of safety (as a percentage). •           Calculate the number of units that must be sold if the company desires an operating profit of $1 350 000. •           Suppose the company wants to spend $120 000 more on advertising and reduce the selling price by $4 per unit, with the expectation that the sales volume will increase by 20%. Is this a...
1. Use information in the balanced chemical formula below to answer the next 4 questions   ...
1. Use information in the balanced chemical formula below to answer the next 4 questions    C2H6                    +       7   F2             →           2 CF4             +         6 HF mw = 30.06 amu                           mw = 37.99 amu                           mw = 88.00 amu               mw=20.00 amu          a) How many moles of C2H6 would be consumed when reacted with 9.24 moles of F2? b) If you consume 7.50 moles of F2, how many grams...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT