(Answered) Problemspelling company has the following sales projection

Accounting

Problem

Spelling Company has the following sales projection (in units) for the next six months:

Feb: 17000
Mar: 19000
Apr: 15000
May: 22000
Jun: 18000
Jul: 13000

Each unit sells for $40.

Spelling has prepared the following sales budget for the quarter of April, May and June:

Sales Budget
	April	May	June	Total
Sales in units	15000	22000	18000	55000
Selling price per unit	x $40	x $40	x $40
Sales revenue	$600000	$880000	$720000	$2200000

Spelling's cost of goods sold is 60% of its sales revenue. The company has a policy that it keeps 10% of next months budgeted cost of goods sold as ending inventory. The company had exactly the budgeted amount of inventory on hand at April 1.

Prepare a purchases budget on paper or, PREFERABLY, in Excel for the quarter of April, May and June. (If you build your schedule using formulas in excel, multiple attempts will be much faster.)

What is the cost of inventory at April 1 (Beginning inventory)

What is the budgeted cost of purchases in May?

What is the desired cost of inventory at the end of the quarter?

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M92650024
Price:- $15

Verified Expert

Priced at $30 Now at $15, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - assume the following is the stockholders equity

Question - Assume the following is the stockholders' equity section of the 2016 Merck & Co., Inc., balance sheet. Stockholders' Equity ($ millions 2016 Common stock, one cent par value; Authorized-5,400,000,000 shares; I ...

Question - wilson carver knives uses process costing in its

Question - Wilson Carver Knives uses process costing. In its Cutting Department, all the materials are added at the beginning of the process and conversion costs are added evenly during the processing. During the first m ...

Question - on january 2 2017 alpha corporation issued 15000

Question - On January 2, 2017, Alpha Corporation issued 15,000 shares of $10 par value common stock for $15 per share. On July 1, 2017, Alpha reacquired 1,000 of these shares when they were trading $20 each. September 1, ...

Question there are six steps in calculating the current and

Question: There are six steps in calculating the current and deferred income tax expense or benefit components of a company's income tax provision. Identify one of the six steps and describe the step in detail, explainin ...

Question - hardcastle ltd had sales of 3 000 000 and net

Question - Hardcastle Ltd. had sales of $3 000 000 and net operating income of $900 000. Operating assets during the year averaged $1 500 000. The manager of Hardcastle is considering the purchase of a new machine which ...

Question - stewart company purchases store supplies for

Question - Stewart Company purchases store supplies for $2,700, paying 20% of the amount due in cash and agreeing to pay the balance at a later date. Required: What is the effect of this transaction on individual asset a ...

Part abackgroundsaturn petcare australia and new zealand

Part A Background: Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their first m ...

Question - on september 1 kennedy company loaned 120000 at

Question - On September 1, Kennedy Company loaned $120,000, at 10% annual interest, to a customer. Interest and principal will be collected when the loan matures one year from the issue date. Assuming adjustments are onl ...

Question - on january 1 2017 boston enterprises issues

Question - On January 1, 2017, Boston Enterprises issues bonds that have a $3,400,000 par value, mature in 20 years, and pay 9% interest semiannually on June 30 and December 31. The bonds are sold at par. Explain how it ...

Question - poe inc had the following bank reconciliation at

Question - Poe, Inc. had the following bank reconciliation at March 31, year 2: Balance per bank statement, 3/31/Y2 $46,500 Add deposit in transit 10,300 56,800 Less outstanding checks 12,600 Balance per books, 3/31/Y2 $ ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert