Question: please post how to do this on excel! Last year's sales for the six-month perio of February to July were $336,900. A 5.5 percent increase

please post how to do this on excel!

Last year's sales for the six-month perio of February to July were $336,900. A 5.5 percent increase in sales is anticipated this year. Total reductions for the period are planned at 8 percent. The buyer desires an ending inventory of $115,000 for the period. A 48 percent initial markup is planned. Based on an analysis of past sales records and current market trends, a buyer has also made plans for the period in relation to (1) monthly distribution of sales, (2) monthly stock-tosales rutios, and (3) monthly distribution of planned reductions. Those planning estimates are presented below: Calculate (1) planned monthly sales, (2) planned monthly BOM, (3) planned monthly EOM, and (4) planned monthly reductions, (5) planned monthly purchases at retail, and (6) planned monthly purchases at cost

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!

I need to create an executive level report on the internal management of Belk. Inc. My assignment is that I am looking to acquire Belk, What information and analysis do I need to have in this report?...

I have attached the Gaps financial report for 2014 which you will need to answer the questions in the assignment. 2014 ANNUAL REPORT Dear Shareholders, It's an honor to write this letter as the CEO...

Using Excel Last year's sales for the 6-month period of February to July were $589,345. A 5 percent increase in sales is anticipated this year. Total reductions for the period are planned at 8...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

There are many challenges when it comes to global strategic plans for businesses. One involves international cash management, due to the risk of currency fluctuations and interest rate changes in the...

need help thank you so much. [The following information applies to the questions displayed below.] "We really need to get this new material-handling equipment in operation just after the new year...

i need work sheet, income statement,statement of retained earnings, balance sheet, Total credit purchase 247,070 Total credit sales 390,690 Total cash receipts 419,651 Total cash disbursement 456,877...

hi, expert, thank you very much for your reply, i really want to paid more for your quality answer, but there is no money left from my bank card, that's the last amount i have, but this work is...

6-month merchandise plan, assortment plan, and word document. Teams: will be assigned by instructor Grade Breakdown by %, 100% total, 100 points total. 6-month merchandise plan: 50% (50 possible...

Hello, Need help with the following:Please see Rubric thks Using information from"Are You Paying Too Much for That Acquisition?" List and describe the components used to calculate synergy value....

A piece of wire is bent through an angle . The bent wire is partially submerged in benzene (index of refraction = 1.50), so that, to a person looking along the dry part, the wire appears to be...

New developments in information technology have simplified the assessment of individual borrowers creditworthiness. What are the likely consequences for the structure of the financial system? For...

Which of the following would be an example of Tier 2 capital? Subordinated debt capital instruments Undivided profits Minority interest in the equity accounts of Donsolidated subsidiaries Qualifying...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...