Several years ago, Westmont Corporation developed a comprehensive budgeting system for planning and control purposes. While departmental supervisors have been happy with the system, the factory manager has expressed considerable dissatisfaction with the information being generated by the system.

A report for the company's Assembly Department for the month of March follows:

After receiving a copy of this cost report, the supervisor of the Assembly Department stated, “These reports are super. It makes me feel really good to see how well things are going in my department. I can’t understand why those people upstairs complain so much about the reports.”

For the last several years, the company’s marketing department has chronically failed to meet the sales goals expressed in the company’s monthly budgets.

Required:

1. The company’s president is uneasy about the cost reports, identify at least two reasons.

2. What kind of reports should be used to give better insight into how well departmental supervisors are controlling costs?

3. Complete the new performance report for the quarter, based on Flexible Budget Performance approach.

4. Were costs well controlled in March?

The company’s president is uneasy about the cost reports, identify at least two reasons. (Select "X" if the item is one of the reasons.)

• What changes, if any, should be made in the reports to give better insight into how well departmental supervisors are controlling costs?

  	Flexible budget performance reports must be usedradio button unchecked1 of 2 Fixed budget performance reports must be usedradio button unchecked

• prepare a new performance report for the quarter, (Do not round your intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

  	Westmont Corporation Assembly Department Flexible Budget Performance Report For the Month Ended March 31 Actual Results Flexible Budget Planning Budget Machine-hours (q) 15,000 20,000 Supplies $10,500 $11,100 Scrap 37,800 40,500 Indirect materials 108,200 129,000 Wages and salaries 82,300 77,000 Equipment depreciation 107,000 107,000 Total $345,800 $364,600

• How well were costs controlled in the Assembly Department in March?

  	Costs were well controlledradio button unchecked1 of 2 Costs were not well controlledradio button unchecked2 of 2

Creative Computing sells a tablet computer called the Protab. The $970 sales price of a Protab Package includes the following:

• One Protab computer.
• A 6-month limited warranty. This warranty guarantees that Creative will cover any costs that arise due to repairs or replacements associated with defective products for up to six months.
• A coupon to purchase a Creative Probook e-book reader for $375, a price that represents a 40% discount from the regular Probook price of $625. It is expected that 20% of the discount coupons will be utilized.
• A coupon to purchase a one-year extended warranty for $60. Customers can buy the extended warranty for $95 at other times if they do not use the $60 coupon. Creative estimates that 30% of customers will purchase an extended warranty.
• Creative does not sell the Protab without the limited warranty, option to purchase a Probook, and the option to purchase an extended warranty, but estimates that if it did so, a Protab alone would sell for $950.

Required:
1. & 2. Indicate below whether each item is a separate performance obligation and allocate the transaction price of 80,000 Protab Packages to the separate performance obligations in the contract.
3. Prepare a journal entry to record sales of 80,000 Protab Packages (ignore any sales of extended warranties).

You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control.

After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March:

During March, the company worked 17,000 machine-hours and produced 11,000 units. The company had originally planned to work 19,000 machine-hours during March.

Required:

1. Calculate the activity variances for March.

2. Calculate the spending variances for March.

Calculate the activity variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Calculate the spending variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Case 9-31 Master Budget with Supporting Schedules [LO9-2, LO9-4, LO9-8, LO9-9, LO9-10]

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.

Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the benefits that can be gained from an integrated budgeting program. To this end, you have worked with accounting and other areas to gather the information assembled below.

The company sells many styles of earrings, but all are sold for the same price—$18 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):

The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month.

Suppliers are paid $5.4 for a pair of earrings. One-half of a month’s purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 20% of a month’s sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.

Monthly operating expenses for the company are given below:

Insurance is paid on an annual basis, in November of each year.

The company plans to purchase $23,000 in new equipment during May and $54,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $25,500 each quarter, payable in the first month of the following quarter.

A listing of the company’s ledger accounts as of March 31 is given below:

The company maintains a minimum cash balance of $64,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.

The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $64,000 in cash.

Required:

1. Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets:

a. A sales budget, by month and in total.

b. A schedule of expected cash collections from sales, by month and in total.

c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. (Round unit cost of purchases to 1 decimal place.)

d. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.

189. Caitlin, Chris, and Molly are partners and share income and losses in a 3:4:3 ratio. The partnership’s capital balances are Caitlin, $137,000; Chris, $97,000; and Molly, $117,000. Paul is admitted to the partnership on July 1 with a 20% equity and invests $77,000. The balance in Caitlin’s capital account immediately after Paul’s admission is:

• $139,580

• $134,420

• $77,000

• $85,600

• $137,000

195. Martin Company purchases a machine at the beginning of the year at a cost of $69,000. The machine is depreciated using the straight-line method. The machine’s useful life is estimated to be 5 years with a $6,000 salvage value. The book value of the machine at the end of year 5 is:

• $27,600.

• $12,600.

• $6,000.

• $63,000.

• $0.

The assignment is to imagine yourself 10 years in the future. I'm basing my salary off the average financial adviser for myself and a school teacher for my wife. (PA). Me $ 76,035 Her $62,260. I need to make a budget.

Personal and Family Expenses

Personal and Family Expenses (continued)

High-Low Method. Castanza Company produces computer printers. Management wants to estimate the cost of production equipment used to produce printers. The company reported the following monthly cost data related to production equipment:

Required:

1. Use the four steps of the high-low method to estimate total fixed costs per month and the variable cost per machine hour. State your results in the cost equation form Y = f + vX by filling in the dollar amounts for f and v.
2. What would Castanza Company’s estimated costs be if it used 50,000 machine hours next month?
3. What would Castanza Company’s estimated costs be if it used 15,000 machine hours next month? Why should you feel uncomfortable estimating costs for 15,000 machine hours?

Creative Computing sells a tablet computer called the Protab. The $970 sales price of a Protab Package includes the following: One Protab computer. A 6-month limited warranty. This warranty guarantees that Creative will cover any costs that arise due to repairs or replacements associated with defective products for up to six months. A coupon to purchase a Creative Probook e-book reader for $200, a price that represents a 50% discount from the regular Probook price of $400. It is expected that 25% of the discount coupons will be utilized. A coupon to purchase a one-year extended warranty for $70. Customers can buy the extended warranty for $70 at other times as well. Creative estimates that 35% of customers will purchase an extended warranty. Creative does not sell the Protab without the limited warranty, option to purchase a Probook, and the option to purchase an extended warranty, but estimates that if it did so, a Protab alone would sell for $950. All Protab sales are made in cash. Required: 1. & 2. Indicated below whether each item is a separate performance obligation and allocate the transaction price of 90,000 Protab Packages to the separate performance obligations in the contract. 3. Prepare a journal entry to record sales of 90,000 Protab Packages (ignore any sales of extended warranties).

Average Rate of Return Method, Net Present Value Method, and Analysis

The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows:

Each project requires an investment of $380,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 15% for purposes of the net present value analysis.

Required:

1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place.

1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value.

2. The warehouse has a   net present value as tracking technology cash flows occur   in time. Thus, if only one of the two projects can be accepted, the   would be the more attractive.

NUMBER THREE:

The financial statements for Castile Products, Inc., are given below:

Account balances at the beginning of the year were: accounts receivable, $190,000; and inventory, $310,000. All sales were on account.

Required:

Compute the following financial data and ratios:

1. Working capital.

2. Current ratio. (Round your answer to 1 decimal place.)

3. Acid-test ratio. (Round your answer to 2 decimal places.)

4. Debt-to-equity ratio. (Round your answer to 2 decimal places.)

5. Times interest earned ratio. (Round your answer to 2 decimal places.)

6. Average collection period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)

7. Average sale period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)

8. Operating cycle. (Round your intermediate calculations and final answer to 1 decimal place.)

Tolson Company purchased a building by paying $85,000. The building has an estimated life of 40 years and an estimated residual value of $5,000.

Required:

A bond’s credit rating provides a guide to its risk. Long-term bonds rated Aa currently offer yields to maturity of 6.0%. A-rated bonds sell at yields of 6.3%. Suppose that a 10-year bond with a face value of $1,000 and a coupon rate of 5.5% is downgraded by Moody’s from an Aa to A rating. Assume annual compounding.

a. What is the likely bond price before the downgrade? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Initial price $

b. What is the likely bond price after the downgrade? (Do not round intermediate calculations. Round your answer to 2 decimal places.) New price $

Crafty Ceramics makes custom ceramic tiles. During March Crafty worked on 25 jobs and purchased $25,600 of raw materials on the account, paid direct labor cost of $31,000, and incurred manufacturing overhead costs of $26,530. Crafty applies overhead at a rate of 80% of direct labor cost.

Job #231, one of the 25 jobs, started and completed during the month. The company’s records show the following direct materials were requisitioned for Job #231: White tiles: 1,000 units at $1.00 per unit, and High Gloss Glaze: 2 quarts at $2.00 per quart. Labor time records show Jenny Jones worked 10 hours at $20 per hour on Job #231.       

Required:

      A) Make journal entries to record the material requisition for Job #231.

• Make journal entry to record the labor cost for Job #231.
• Make journal entry to apply [i.e., to allocate] the manufacturing overhead to Job #231.

D) Given the total production costs for this month over all the jobs, make journal entries:

       (1) to apply the total manufacturing overhead to all 25 jobs, and

       (2) to close under- [or over-] applied overhead to the firm’s cost of goods sold account.

Average Rate of Return, Cash Payback Period, Net Present Value Method

Bi-Coastal Railroad Inc. is considering acquiring equipment at a cost of $144,000. The equipment has an estimated life of 10 years and no residual value. It is expected to provide yearly net cash flows of $72,000. The company’s minimum desired rate of return for net present value analysis is 12%.

Compute the following:

a. The average rate of return, assuming the annual earnings are equal to the net cash flows less the annual depreciation expense on the equipment. If required, round your answer to one decimal place.
%

b. The cash payback period.
  years

c. The net present value. Use the above table of the present value of an annuity of $1. Round to the nearest dollar. If required, use a minus sign to indicate negative net present value" for current grading purpose.