Prepare the budgets and schedules
Course:- Finance Basics
Reference No.:- EM131298446

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Finance Basics

Cryon Corporation manufactures and sells a seasonal product that has a peak in sales in the third quarter. The following information reflects projections for Year 2 - the coming year - and the first quarter of Year 3.

Units sell at $10 each. Budgeted sales for the next 5 quarters are outlined below.

Year 2 Quarter           Year 3
1    2    3    4    1
50,000    70,000    120,000    70,000    60,000

Sales are collected in the following pattern: 75% are collected in the quarter the sales are made, and the remaining 25% are collected in the following quarter. On January 1, Year 2, the company had accounts receivable of $65,000, all of which will be collected in the first quarter of Year 2. Bad debts are negligible and can be ignored.

The company desires finished goods inventory at the end of each quarter equal to 30% of the budgeted unit sales for the next quarter. On December 31, Year 1, the company had 15,000 completed units on hand.

Five pounds of raw materials inventory is required to complete one unit of product. The company requires ending raw materials inventory at the end of each quarter equal to 10% of the following quarter's production needs. On December 31, Year 1, the company had 38,000 pounds of raw material on hand.

Raw material cost is $0.80 per pound.


Prepare the following budgets and schedules for Year 2, showing quarterly figures:

Sales budget

Schedule of expected cash collections

Production budget

Direct materials budget that summarizes both pounds and dollars.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Finance Basics) Materials
Scenario: The spot British pound is $1.933 and the six-month forward rate is $1.925. The annualized six-month Eurodollar rate is 5.4% and the volatility of the British pound
Imagine you are considering the possibility of operating a small business or practice related to health care, either as a provider of some sort of care or as a service inten
App Store Co. issued 13-year bonds one year ago at a coupon rate of 8 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.7 percent, what is the curren
Bank of America has extended our review of foreclosure documents to all fi fty states. We will stop foreclosure sales until our assessment has been satisfactorily completed.
In your lifetime, do you think companies such as Coke, McDonald's, or Google will be overtaken by new, entrepreneurial companies? In a 200-250 word response, indicate why yo
Here's your chance!  Carpet Cleaning Van for sale.   Provide REALISTIC assumptions in an NPV analysis as to whether this could be a positive NPV opportunity.  Be certain to in
Assume that whirledcom has an issue of 15 year $1000. par value bonds that pay 6% interest, semi-annually. further assume that todays required rate of return on these bonds
You will need to borrow $250,000 to buy your dream home. A bank quotes you a 5 year fixed 15 yearterm at 9.17% APR with semi-annual compounding. What is closest to your mont