The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data:

The following additional information is available:  

1. The company’s plant has a capacity of 113,140 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products.

2. The direct labor rate of $9 per hour is expected to remain unchanged during the coming year.

3. Fixed manufacturing costs total $630,000 per year. Variable overhead costs are $2 per direct labor-hour.

4. All of the company’s nonmanufacturing costs are fixed.

5. The company’s finished goods inventory is negligible and can be ignored.

Required:

1. How many direct labor hours are used to manufacture one unit of each of the company’s five products?

2. How much variable overhead cost is incurred to manufacture one unit of each of the company’s five products?

3. What is the contribution margin per direct labor-hour for each of the company’s five products?

4. Assuming that direct labor-hours is the company’s constraining resource, what is the highest total contribution margin that the company can earn if it makes optimal use of its constrained resource?

Coolbrook Company has the following information available for the past year:   

   
The company’s hurdle rate is 7.76 percent.

Required:
1. Calculate return on investment (ROI) and residual income for each division for last year. (Enter your ROI answers as a percentage rounded to two decimal places, (i.e., 0.1234 should be entered as 12.34%.))



2. Recalculate ROI and residual income for each division for each independent situation that follows: (Enter your ROI answers as a percentage rounded to two decimal places, (i.e., 0.1234 should be entered as 12.34%.))

a. Operating income increases by 9 percent.



b. Operating income decreases by 9 percent.



c. The company invests $246,000 in each division, an amount that generates $107,000 additional income per division.



d. Coolbrook changes its hurdle rate to 5.76 percent.

The Dauten Toy Corporation uses an injection molding machine that was purchased prior to the new tax legislation. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $2,100/6 = $350 per year. If the old machine is not replaced, it can be sold for $500 at the end of its useful life.

Dauten is offered a replacement machine which has a cost of $8,000, an estimated useful life of 6 years, and an estimated salvage value of $800. The replacement machine is eligible for 100% bonus depreciation at the time of purchase. The replacement machine would permit an output expansion, so sales would rise by $1,000 per year; even so, the new machine's much greater efficiency would cause operating expenses to decline by $1,500 per year. The new machine would require that inventories be increased by $2,500, but accounts payable would simultaneously increase by $800. Dauten's marginal federal-plus-state tax rate is 25%, and its WACC is 11%.

What is the NPV of the incremental cash flow stream? Negative value, if any, should be indicated by a minus sign. Round your answer to the nearest cent.
$  

Schedule of Cash Receipts

Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.60 per check; the amount per check averages $75. “Bad” checks that Rosita cannot collect make up 4 percent of check revenue.

During a typical month, Rosita's has sales of $49,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows:

Required:

Prepare a schedule of cash receipts for May and June. Round your intermediate computations and final answers to the nearest whole dollar.

Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:

Beech’s managers have made the following additional assumptions and estimates:

1. Estimated sales for July, August, September, and October will be $290,000, $310,000, $300,000, and $320,000, respectively.

2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July.

3. Each month’s ending inventory must equal 30% of the cost of next month’s sales. The cost of goods sold is 70% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July.

4. Monthly selling and administrative expenses are always $54,000. Each month $5,000 of this total amount is depreciation expense and the remaining $49,000 relates to expenses that are paid in the month they are incurred.

5. The company does not plan to borrow money or pay or declare dividends during the quarter ended September 30. The company does not plan to issue any common stock or repurchase its own stock during the quarter ended September 30.

Required:

1. Prepare a schedule of expected cash collections for July, August, and September. Also compute total cash collections for the quarter ended September 30.

2-a. Prepare a merchandise purchases budget for July, August, and September. Also compute total merchandise purchases for the quarter ended September 30.

2-b. Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September. Also compute total cash disbursements for merchandise purchases for the quarter ended September 30.

3 Prepare an income statement for the quarter ended September 30.

4 Prepare a balance sheet as of September 30.

Stampede Corporation, a Calgary based steak house, used the following data to evaluate their current operating system. The company sells items for $20 each and used a budgeted selling price of $20 per unit.

Required:

1) Prepare a Level 1 static-budget variance analysis for Stampede Corporation using an income statement in contribution margin format. Use the following three column headings: Actual Results, Static Budget, and Static-budget Variance.

Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements:

The finished goods inventory on hand at the end of each month must equal 3,000 units of Supermix plus 20% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 17,200 units.

The raw materials inventory on hand at the end of each month must equal one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 108,000 cc of solvent H300.   

The company maintains no work in process inventories.

A monthly sales budget for Supermix for the third and fourth quarters of the year follows.

Required:

Prepare a production budget for Supermix for the months July, August, September, and October.

Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $85,000; accounts receivable, $265,000; and accounts payable, $86,000.

• Mary and Kay, Inc. maintains a $85,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

Required:

1. Prepare a schedule that discloses the firm’s total cash collections for January through March.

2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

3. Prepare a schedule that summarizes the firm’s financing cash flows for January through March.

Job Costs Using a Plantwide Overhead Rate

Naranjo Company designs industrial prototypes for outside companies. Budgeted overhead for the year was $187,500, and budgeted direct labor hours were 15,000. The average wage rate for direct labor is expected to be $25 per hour. During June, Naranjo Company worked on four jobs. Data relating to these four jobs follow:

Overhead is assigned as a percentage of direct labor cost. During June, Jobs 39 and 40 were completed; Job 39 was sold at 125 percent of cost. (Naranjo had originally developed Job 40 to order for a customer; however, that customer was near bankruptcy and the chance of Naranjo being paid was growing dimmer. Naranjo decided to hold Job 40 in inventory while the customer worked out its financial difficulties. Job 40 is the only job in Finished Goods Inventory.) Jobs 41 and 42 remain unfinished at the end of the month.

Required:

1. Calculate the balance in Work in Process as of June 30.

$

2. Calculate the balance in Finished Goods as of June 30.

$

3. Calculate the cost of goods sold for June.

$

4. Calculate the price charged for Job 39. Round your answer to the nearest cent.

$

5. What if the customer for Job 40 was able to pay for the job by June 30? What would happen to the balance in Finished Goods?

What would happen to the balance of Cost of Goods Sold?

Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows:

The company’s beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded.

Required:

Prepare the company’s cash budget for the upcoming fiscal year. (Cash deficiency, repayments and interest should be indicated by a minus sign.)

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $80,000; accounts receivable, $260,000; and accounts payable, $85,000.

• Mary and Kay, Inc. maintains a $80,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

Required:

1. Prepare a schedule that discloses the firm’s total cash collections for January through March.

2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

3. Prepare a schedule that summarizes the firm’s financing cash flows for January through March.

Mexican Motors’ market cap is 200 billion pesos. Next year’s free cash flow is 8.6 billion pesos. Security analysts are forecasting that free cash flow will grow by 7.60% per year for the next five years.

a. Assume that the 7.60% growth rate is expected to continue forever. What rate of return are investors expecting? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

Rate of Return:_________%

b-1. Mexican Motors has generally earned about 10% on book equity (ROE = 10%) and reinvested 50% of earnings. The remaining 50% of earnings has gone to free cash flow. Suppose the company maintains the same ROE and investment rate for the long run. What will be the growth rate of earnings? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal places.)

Growth Rate: ______%

b-2. What would be the rate of return? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

Rate of return:_____%

Job Cost Sheet

Remnant Carpet Company sells and installs commercial carpeting for office buildings. Remnant Carpet Company uses a job order cost system. When a prospective customer asks for a price quote on a job, the estimated cost data are inserted on an unnumbered job cost sheet. If the offer is accepted, a number is assigned to the job, and the costs incurred are recorded in the usual manner on the job cost sheet. After the job is completed, reasons for the variances between the estimated and actual costs are noted on the sheet. The data are then available to management in evaluating the efficiency of operations and in preparing quotes on future jobs. On October 1, Remnant Carpet Company gave Jackson Consulting an estimate of $2,418 to carpet the consulting firm’s newly leased office. The estimate was based on the following data:

On October 3, Jackson Consulting signed a purchase contract, and the delivery and installation were completed on October 10.

The related materials requisitions and time tickets are summarized as follows:

Required:

Enter amounts as positive numbers.

1. Complete that portion of the job order cost sheet that would be prepared when the estimate is given to the customer.

2. Record the costs incurred, and complete the job order cost sheet.

What is the best explanation for the variances between actual costs and estimated costs. (For this purpose, assume that the additional meters of material used in the job were spoiled, the factory overhead rate has proven to be satisfactory, and an inexperienced employee performed the work.)

1. The direct materials cost exceeded the estimate by $136 because 4 meters of materials were spoiled. The direct labor cost exceeded the estimate by $120 because an additional 4 hours of labor were used by an inexperienced employee. The factory overhead cost exceeded the estimate because an additional $90 of factory overhead was allocated because of the increase in direct labor.
2. Management didn't provide enough direction to complete tasks on budget.
3. The direct materials cost exceeded the estimate by $75 because 3 meters of materials were spoiled.
4. The direct labor cost exceeded the estimate by $120 because an additional 4 hours of labor were used by an inexperienced employee.

Select the correct answer from the above choices.
a, b, c, d

McKnight Company is considering two different, mutually exclusive capital expenditure proposals. Project A will cost $511,000, has an expected useful life of 12 years, a salvage value of zero, and is expected to increase net annual cash flows by $74,300. Project B will cost $330,000, has an expected useful life of 12 years, a salvage value of zero, and is expected to increase net annual cash flows by $49,600. A discount rate of 8% is appropriate for both projects. Click here to view PV table.

Compute the net present value and profitability index of each project. (If the net present value is negative, use either a negative sign preceding the number eg -45 or parentheses eg (45). Round present value answers to 0 decimal places, e.g. 125 and profitability index answers to 2 decimal places, e.g. 15.25. For calculation purposes, use 5 decimal places as displayed in the factor table provided.)

Net present value - Project A $

Profitability index - Project A

Net present value - Project B $

Profitability index - Project B

Which project should be accepted based on Net Present Value? choice project a/ project b

Which project should be accepted based on profitability index? choice project a/ project b