Reference no: EM131021008
Soprano Co. is in the process of preparing the second quarter budget for 2013, and the following data have been assembled:
'The company sells a single product at a selling price of $41 per unit. The estimated sales volume for the next six months is as follows:
March 6,000 units
April 7,300 units
May 10,100 units
June 8,200 unit
July 9,300 unit
August 6,300 unit
All sales are on account. The company's collection experience has been that 41% of a month's sales are collected in the month of sale, 51% are collected in the month following the sale, and 8% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e.. accounts receivable less allowance for uncollectible accounts) will be $125,460 on March 31, 2013.
- Management's policy is to maintain ending finished goods inventory each month at a level equal to 53% of the next month's budgeted sales. The finished goods inventory on March 31, 2013, is expected to be 3.869 units.
- To make one unit of finished product. 4 pounds of materials are required. Management's policy is to have enough materials on hand at the end of each month to equal 41% of the next month's estimated usage. The raw materials inventory is expected to be 14,406 pounds on March 31, 2013.
The cost per pound of raw material is $6.00, and 78% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. The accounts payable balance for raw material purchases is expected to be $39,853 on March 31. 2013.
Required:
a. Prepare a sales budget in units and dollars, by month and in total. for the second quarter (April, May, and June) of 2013.
b. Prepare a schedule of cash collections from sales, by month and in total, for the second quarter of 2013.
c. Prepare a production budget in units, by month and in total, for the second quarter of 2013.
Prepare a materials purchases budget in pounds, by month and in total, for the second quarter of 2013. (Round your answers to whole number.)
Prepare a schedule of cash payments for materials, by month and in total, for the second quarter of 2013. (Round your answers to whole number.)
|
What is the price you would pay for this stock now
: Credenza Industries is expected to pay a dividend of $1.20 at the end of the coming year. It is expected to sell for $62.00 at the end of the year. If its equity cost of capital is 8%, what is the price you would pay for this stock now?
|
|
Profitability index when evaluating projects
: Company uses the profitability index (PI) when evaluating projects. The cost of capital is 14.52 percent. What is the PI of a project if the initial costs are $2351733 and the project life is estimated as 5 years? The project will produce the same af..
|
|
Amortizing loan to purchase an apartment
: Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan has 4.8% APR with monthly payments of $1000. How much do you owe on the loan today?
|
|
What is the book value per share for a firm
: What is the book value per share for a firm with 2 million shares outstanding at a price of $50, a market-to-book ratio of .75, and a dividend payout ratio of 50%?
|
|
Prepare a sales budget in units and dollars by month and
: Prepare a sales budget in units and dollars, by month and in total. for the second quarter (April, May, and June) of 2013. Prepare a schedule of cash collections from sales, by month and in total, for the second quarter of 2013. prepare a production ..
|
|
Analysis you might perform in considering this use of funds
: The head of the hearing department at your outpatient clinic wants to purchase a new state-of-the-art audiology diagnostic suite for $4000,000. You have been asked to review he request. What are some examples of the types of analysis you might perfor..
|
|
Prepare journal entries to record depreciation of machine
: Prepare journal entries to record depreciation of the machine at December 31 - The year of its disposal.
|
|
Olympic sports has two issues of debt outstanding
: Olympic Sports has two issues of debt outstanding. One is a 7% coupon bond with a face value of $37 million, a maturity of 10 years, and a yield to maturity of 8%. The coupons are paid annually. The other bond issue has a maturity of 15 years, with c..
|
|
About the percentage cost of the preferred stock
: Pangbourne Whitchurch has preferred stock outstanding. The stock pays a dividend of $3 per share, and sells for $30. What is the percentage cost of the preferred stock? (Enter your answer as a whole percent.)
|