xercise D5 10 Rossano, Inc , makes and sells drum sets Nick Ross, controller, is responsible for preparing the master budget The sales manager has given Nick the following sales forecast for the coming months April May June July Forecasted unit sales 12,000 15,000 10,000 11,000 Rossano expects to have 6,000 drum sets in ending inventory on March 31 The company's policy is to carry 30 of the following month's projected sales in ending inventory Prepare Rossano's production budget for the second quarter (Round answers to 0 decimal places, e g 5,275 ) I need it with excel formulas

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

Question: xercise D5-10 Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given Nick

xercise D5-10

Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given Nick the following sales forecast for the coming months.

			April		May		June		July
	Forecasted unit sales		12,000		15,000		10,000		11,000

Rossano expects to have 6,000 drum sets in ending inventory on March 31. The company's policy is to carry 30 % of the following month's projected sales in ending inventory. Prepare Rossano's production budget for the second quarter. (Round answers to 0 decimal places, e.g. 5,275.)

I need it with excel formulas!

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 Accounting Questions!

June 1: Company issues $25,000 common stock at par. June 1: Company purchased a company vehicle in the amount of $17,000. June 3: Company took out a business loan in the amount of $15,000. June 5:...

Exercise D5-10 Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given Nick the following sales forecast for the...

I need help with preparing a production budget 5.10 (L0 3) Preparing a production budget (CMA adapted) Rossano, Inc, makes and sells drum sets. Nick Ross, controller, is responsible for preparing the...

5-10 Preparing a production budget (CMA adapted) (LO 3) Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given...

H L M N O P 0 R Student Work Area Required: Provide input into cells shaded in yellow in this template. Input mathematical formulas with cell references to the Problem area as indicated. Use the SUM...

Exercise 5-10 Preparing A Production Budget (CMA Adapted) Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given...

can i get the excel solutions for the highlighted portion? E5.10 - Using Excel to Prepare a Production Budget PROBLEM Rossano, Inc., makes and sells drum sets. Nick Ross controller, is responsible...

Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given Nick the following sales forecast for the coming months....

Question 2 of 5 - /20 !!! View Policies Current Attempt in Progress Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager...

A friend of yours just invested in an outstanding bond with a 6% annual coupon and a remaining maturity of 15 years. The bond has a par value of $1,000 and the market interest rate is currently 8%....

NR Industries has 135,000 shares of common stock outstanding. The stock is currently selling for $57 a share. The firm also has 2 bond issues outstanding. The first bond issue has a total face value...

During the presentation, you must: Explain the contents of the budget Inform the group of the reporting requirements Explain the financial delegations Ask questions to confirm the information has...

Alphabet has created a simple, easily understood mission. True False

What literature and information sources are available to you (physically and electronically) from: your study centre; your place of work; any professional institutions of which you or your...

How familiar are you with HR related internet gateways and other search engines?

Which academic journals are you already familiar with and which do you find the most challenging to analyse?