BUSI 2083: Introduction to Managerial Accounting
unit excercises
Table of Contents
Question 1 (Total: 18 marks)
The following information was taken from the accounting records of Dunbar Mifflin Company in 2018.
Beginning of 2018 Ending of 2018
Direct materials inventory 135,000 83,000
Work-in-process inventory 185,000 154,000
Finished-goods inventory 255,000 216,000
Purchases of direct materials 270,000
Direct manufacturing labor 225,000
Indirect manufacturing labor 103,000
Plant insurance 11,000
Depreciation-plant, building, and equipment 48,000
Plant utilities 29,500
Repairs and maintenance-plant 13,500
Equipment leasing costs 66,800
Marketing, distribution, and customer-service costs 129,500
General and administrative costs 72,500
Required:
- Prepare a schedule of cost of goods manufactured.
Question 2 (Total: 38 marks)
Following are the account balances for the DC Company in 2018:
Beginning of 2018 Ending of 2018
Direct materials inventory 26,500 27,000
Work-in-process inventory 30,500 28,400
Finished-goods inventory 16,500 22,100
Purchases of direct materials 79,000
Direct manufacturing labor 24,500
Indirect manufacturing labor 18,600
Plant insurance 7,900
Depreciation-plant, building, and equipment 11,800
Repairs and maintenance-plant 3,500
Marketing, distribution, and customer-service costs 87,900
General and administrative costs 26,500
Required:
- Prepare a schedule for the cost of goods manufactured for 2018.
- Revenues for 2018 was $425,000. Prepare the income statement for 2018.
Question 3 (Total: 30 marks)
Identify if the following costs are “product” or “period” costs:
COST | Period Cost or Product Cost? |
1. Television advertisements for Bailey’s products | |
2. Lubricants used in running bottling machines | |
3. Research and Development related to elimination of antibiotic residues in milk | |
4. Gasoline used to operate refrigerated trucks delivering finished dairy products to grocery stores | |
5. Company president’s annual bonus | |
6. Depreciation on refrigerated trucks used to collect raw milk | |
7. Plastic gallon containers in which milk is packaged | |
8. Property insurance on dairy processing plant | |
9. Cost of milk purchased from local dairy farmers | |
10. Depreciation on tablets used by sales staff | |
11. Depreciation on chairs and tables in the factory lunchroom. | |
12. The cost of packaging the company’s product. | |
13. The wages of the receptionist in the administrative offices. | |
14. Cost of leasing the corporate jet used by the company’s executives. | |
15. The cost of renting rooms at a BC resort for the annual conference. |
Question 4 (Total: 14 marks)
The Trump International Hotel & Tower is a five-star hotel located in downtown Toronto. The hotel’s operations vice president would like to replace the hotel’s legacy computer terminals at the registration desk with attractive state-of-the-art flat-panel displays. The new displays would take less space, consume less power than the old computer terminals, and provide additional security, since they can be viewed only from a restrictive angle. The new computer displays would not require any new wiring. However, the hotel’s chef believes the funds would be better spent on a new bulk freezer for the kitchen.
Required:
- Classify each item as a differential cost, an opportunity cost, or a sunk cost in the decision to replace the old computer terminals with new flat-panel displays. If none of the categories apply for a particular item, select “None”.
Item | Differential Cost | Opportunity Cost | Sunk Cost | None |
Cost of the old computer terminals | ||||
Rent on the space occupied by the registration desk | ||||
Benefits from a new freezer | ||||
Cost of removing the old computer terminals | ||||
Cost of the new flat-panel displays | ||||
Wages of registration desk personnel | ||||
Cost of existing registration desk wiring |
Question 1 (Total: 36 marks)
The following costs are attributed to the Gandalf and Company:
Purchase of raw materials (all direct) | $291,100 |
Direct labour cost | 141,800 |
Manufacturing overhead costs | 198,100 |
Change in inventories: | |
Decrease in raw materials | $9,100 |
Decrease in work in process | 4,100 |
Decrease in finished goods | 13,200 |
Gandalf and Company used a 120% predetermined overhead rate based on direct labour cost.
Required:
- Calculate the cost of goods manufactured.
- What was the cost of goods sold before adjusting for any under or over applied overhead?
- By how much was manufacturing overhead cost under or over applied?
- Prepare a summary journal entry to close any under or over applied manufacturing overhead cost to cost of goods sold. Is such an entry appropriate in this situation? Why or why not?
Question 2 (Total: 20 marks)
The weighted-average method is used by the Cardiff and Company. Below you will find information provided by the Heating department for the month of March:
Costs for March: | Materials | Conversion |
Work in process, March 1 | $19,200 | $23,100 |
Added during the month | $89,000 | $99,000 |
Units | Conversion percentage complete | |
Work in process, March 1 | 10,000 | 50% |
Units started | 28,000 | |
Completed and transferred out | 19,900 | |
Work in process, March 31 | 5,000 | 30% |
Required:
Cardiff and Company using the weighted-average method, all materials at the first process:
- The equivalent units (EUs) of production for materials.
- The cost per equivalent unit for conversion.
- The total cost assigned to units transferred out of the Heating Department during March.
- The cost assigned to work-in-process inventory as of March 31.
Question 3 (Total: 30 marks)
Paddle Place manufactures paddles and tables. In December, the two production departments had budgeted allocation bases of 3,100 machine-hours in Paddle and 6,900 direct manufacturing labor-hours in Table. The budgeted manufacturing overheads for the month were $51,200 and $56,900, respectively. For Project X, the actual costs incurred in the two departments were as follows:
Paddle | Table | |
Direct materials purchased on account | $80,000 | $177,500 |
Direct materials used | 21,200 | 12,200 |
Direct manufacturing labor | 41,900 | 53,500 |
Indirect manufacturing labor | 8,900 | 9,000 |
Indirect materials used | 5,100 | 4,750 |
Lease on equipment | 14,100 | 3,750 |
Utilities | 990 | 1,250 |
Project X incurred 900 machine-hours in Paddle and 200 manufacturing labor-hours in Table. The company uses a budgeted overhead rate for applying overhead to production.
Required:
- Determine the budgeted manufacturing overhead rate for each department.
- Prepare the journal entries for Paddle department.
- What is the total cost of Project X?
Question 4 (Total: 14 marks)
Identify the following situations as “job-order costing” or “process costing”?
Situation | Job Order or Process Costing |
An oil refinery | |
A soft-drink bottler | |
A film studio | |
A manufacturer of fine custom jewelry | |
A textbook publisher | |
A paint factory | |
A golf course designer |
Question 1 (Total: 20 marks)
For its overhead costs, the wholesale distributor Janz Company uses activity-based costing. In terms of the company’s annual overhead costs and its activity-based costing system the following data has been provided:
Overhead Costs: | |
Wages and salaries | $380,000 |
Non-wage expenses | 90,000 |
Total | $470,000 |
Distribution of Resource Consumption:
Activity Cost Pools | ||||
Filling Orders | Product Support | Other | Total | |
Wages and salaries | 20% | 65% | 15% | 100% |
Non-wage expenses | 15% | 60% | 25% | 100% |
The “Other” activity cost pool consists of the costs of idle capacity and organization-sustaining costs. Shown below is the amount of activity for the year:
Activity Cost Pool | Annual Activity |
Filling orders | 3,100 orders |
Product support | 32 products |
Other | Not applicable |
Required:
Compute the activity rates for the Filling Orders and Product Support activity cost pools
Question 2 (Total: 30 marks)
Lojay Company produces custom covers for the air conditioning units of homes and businesses. For its overhead costs the company uses an activity-based costing system. The following data has been provided by the Lojay company regarding its annual overhead costs and its activity cost pools:
Overhead Costs: | |
Production overhead | $89,000 |
Office expenses | 41,500 |
Total | $130,500 |
Distribution of Resource Consumption:
Activity Cost Pools | ||||
Making Covers | Job Support | Other | Total | |
Production overhead | 33% | 45% | 22% | 100% |
Office expenses | 14% | 54% | 32% | 100% |
The “Other” activity cost pool consists of the costs of idle capacity and organization-sustaining costs. The amount of activity for the year is as follows:
Activity Cost Pool | Annual Activity |
Making covers | 2,500 yards |
Job support | 200 jobs |
Other | Not applicable |
Required:
- Prepare the first-stage allocation of overhead costs to the activity cost pools
- Compute the activity rates for the Making Covers and Job Support activity cost pools
- Prepare a revenue report where making 50 yards of covers and DM and DL cost of $950, and revenue is $2,500
Question 3 (Total: 30 marks)
Tuggs Corporation manufactures two products, Racket and Table. Table, having been developed as an attempt to enter a market closely related to that of Racket, has been recently created. Of the two products Table is the more complex one thus requiring two and a half hours of direct labour time per unit to manufacture, compared to one hour of direct labour time for Racket. Table is produced on an automated production line.
On the basis of direct labour hours Overhead is currently assigned to the products. The company
estimated it would incur $364,000 in manufacturing overhead costs and produce 4,900 units of Table and 22,100 units of Racket during the current year. Unit costs for materials and direct labour are as follows:
Racket | Table | |
Direct materials | $9 | $20 |
Direct labour | $7 | $15 |
Required:
- Compute the predetermined overhead rate under the current method of allocation and determine the unit product cost of each product for the current year.
- The company’s overhead costs can be attributed to four major activities. These activities and the amount of overhead cost attributable to each for the current year are given below:
Expected Activity | ||||
Activity Cost Pool | Estimated Overhead Cost | Racket | Table | Total |
Machine setups required | $161,000 | 800 | 700 | 1,500 |
Purchase orders issued | $32,000 | 200 | 150 | 350 |
Machine hours required | $81,000 | 3,900 | 7,000 | 10,900 |
Maintenance requests issued | $90,000 | 310 | 510 | 820 |
Total | $364,000 |
Determine the unit product cost of each product for the current year using the data above and an activity-based costing approach.
Question 4 (Total: 20 marks)
Gandalf and Company makes Golf Equipment for the retailers around the world. Below you will find a number of activities and cost at Gandalf Corporation. Please list the activity as either, “Batch”, “Unit”, “Product” or “Organization-sustaining”.
Activity | Level |
Factory utilities | |
A steering wheel is installed in a golf cart. | |
Machine set-up. | |
Completed golf carts are individually tested on the company’s test track. | |
Molding and sanding each unit of product | |
An outside lawyer draws up a new generic sales contract for the company, limiting Gandalf’s liability in case of accidents that involve its golf carts. | |
Electricity is used to heat and light the factory and the administrative offices. | |
A golf cart is painted. | |
Research and development on golf cart batteries | |
The company’s engineer modifies the design of a model to eliminate a potential safety problem. |
Question 1 (Total: 26 marks)
Dundar Mifflin manufactures and sells three products: X, Y, and Z. Annual fixed costs are $515,250 and data about the three products follow for 2017.
X | Y | Z | |
Sales | $150,000 | $480,000 | $790,000 |
Variable cost | 80,000 | 175,000 | 290,000 |
Required:
- Determine the breakeven point
- The management expects sales to increase by 9% in 2018. What is the expected operating income in 2018?
Question 2 (Total: 24 marks)
Dundar Mifflin makes electronic product for the RCMP. The following data is for the first six months:
Direct Labor Hours | Manufacturing Overhead | |
January | 45,000 | $295,000 |
February | 60,000 | $320,000 |
March | 57,000 | $323,000 |
April | 52,000 | $247,250 |
May | 34,000 | $178,200 |
June | 25,000 | $162,500 |
Required:
- Use the high-low method to estimate the cost formula
- Estimate the total overhead cost at an activity level of 48,000 machine hours, using the separate estimates you obtained for its components.
Question 3 (Total: 30 marks)
Costco has recently started to take the customer orders over the web site. Following is the past data for first six month:
Month | Customer Web site costs | Number of Web site hits |
January | $8,960 | 11,600 |
February | $8,762 | 11,270 |
March | $9,032 | 11,720 |
April | $8,942 | 11,570 |
May | $8,420 | 10,700 |
June | $8,492 | 10,820 |
Required:
- Using the high-low method, estimate the variable cost per Web site hit and the monthly fixed costs.
- Determine the cost equation to estimate the customer Web site expenses for Costco Online.
- If Costco expects 9,500 Web site hits for July, what are their anticipated costs for July?
Question 4 (Total: 20 marks)
Gandalf and Company makes table tennis equipment for the retailers around the world. Below is listed a number of activities and cost at Gandalf Corporation. Please list the activities as one of the following: fixed, mixed, contribution, cost behavior, variable, curvilinear, account analysis, regression analysis.
1 | Changes in cost, but not in direct proportion to changes in volume | |
2 | Costs that do not change while changes in volume | |
3 | Sales – Variable Expense | |
4 | Cost changes as volume changes | |
5 | Cost that changes while changes in volume | |
6 | Cost behavior is not linear | |
7 | Equation which expresses how a cost behaves | |
8 | Procedure that uses all the historical data points | |
9 | Utility charges per kilowatt plus monthly fee | |
10 | Monthly rent charges |
Question 1 (Total: 40 marks)
Stark and Company would like to evaluate one of the product lines that they sell to the defense department. Every month the Stark and Company produce an identical number of units, although the sales in units differ from month to month.
Selling price | $105 |
Units in beginning inventory | 110 |
Units produced | 6,400 |
Units sold | 6,100 |
Units in ending inventory | 600 |
Variable costs per unit: | |
Direct materials | $62 |
Direct labour | $48 |
Variable manufacturing overhead | $3 |
Variable selling and administrative | $7 |
Fixed costs: | |
Fixed manufacturing overhead | $64,000 |
Fixed selling and administrative | $35,600 |
Required:
- Under variable costing, identify the unit product cost for the month.
- What is the unit product cost for the month under absorption costing?
- Prepare an income statement for the month using the contribution format and the variable costing method.
- Prepare an income statement for the month using the absorption costing method.
Question 2 (Total: 12 marks)
The following information pertains to Death Star Corporation for a period:
Selling price per unit | 49 |
Standard fixed manufacturing costs per unit | 24 |
Variable selling and administrative costs per unit | 3 |
Fixed selling and administrative cost | 14900 |
Beginning inventories: | |
Units | ? |
Standard fixed manufacturing cost | 36,900 |
Standard variable manufacturing cost | 18,700 |
Units produced | 8,900 |
Units sold | 8,600 |
Required:
- Assume the unit standard costs data for the beginning and ending inventories remained constant during the period. What was the total standard cost of the ending inventory under absorption costing?
Question 3
DC-Marvel would like to evaluate one of the product lines that they sell to defense department. Every month the company produces an identical number of units, although the sales in units differ from month to month.
Product B | |
Selling price | $109 |
Units in beginning inventory | 360 |
Units produced | 6,900 |
Units sold | 7,200 |
Variable costs per unit: | |
Direct materials | $29 |
Direct labour | $31 |
Variable manufacturing overhead | $2 |
Variable selling and administrative | $7 |
Fixed costs: | |
Fixed manufacturing overhead | $53,500 |
Fixed selling and administrative | $145,000 |
Required:
Compute the Contribution Margin.
Compute the Operating Income under Variable Costing.
Prepare a reconciliation from your Operating Income under Variable Costing to Operating Income under Absorption Costing. Show the differences between each method.
Question 4 (Total: 18 marks)
Stark and Company’s has following cost data:
Systems development | $29,000 |
Final product testing and inspection | $12,000 |
Quality data gathering, analysis, and reporting | $ 9,000 |
Net cost of scrap | $58,000 |
Customer returns arising from quality problems | $56,000 |
Amortization of testing equipment | $53,000 |
Rework labour and overhead | $16,000 |
Testing and inspection of incoming materials | $38,000 |
Product recalls | $33,000 |
Required:
- Determine the total prevention costs?
- Determine total appraisal costs?
- Determine the total internal failure costs?
Question 1 (Total: 30 marks)
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows:
Jan | Feb | Mar | |
Sales | 49,000 | 51,000 | 56,000 |
Production | 53,000 | 48,000 | 49,000 |
Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the next month. $95,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals $185,000, which will be paid in February.
All units are sold on account for $13 each. Cash collections from sales are budgeted at 55% in the month of sale, 25% in the month following the month of sale, and the remaining 20% in the second month following the month of sale. On January 1 accounts receivable totaled $500,000 ($90,000 from November’s sales and the remaining from December).
Required:
- Prepare a schedule for each month showing budgeted cash disbursements for Cloaks Company.
- Prepare a schedule for each month showing budgeted cash receipts for Cloaks Company.
Question 2 (Total: 36 marks)
A merchandising firm by the name of Star Wars Enterprises, had an inventory of 42,000 units on March 31, and it had accounts receivable totaling $83,500. Sales, in units, have been budgeted as follows for the next four months:
April | 55,000 |
May | 65,000 |
June | 81,000 |
July | 79,000 |
To be enforced in April, Star Wars board of directors has established a policy that states that the inventory at the end of each month should contain 35% of the units required for the following month’s budgeted sales. $2.5 is the selling price per unit. One-Quarter of sales are paid for by customers in the month of the sale; the balance is collected in the following month.
Required:
- Prepare a merchandise purchases budget showing how many units should be purchased for
each of the months April, May, and June.
- Prepare a schedule of expected cash collections for each of the months April, May, and June.
Question 3 (Total: 24 marks)
Fonsey Corporation, a merchandising company, has provided the following budget data:
Purchases | Sales | Month |
$39,500 | $69,000 | January |
47,200 | 65,900 | February |
37,500 | 61,200 | March |
55,000 | 79,850 | April |
59,500 | 66,100 | May |
Collections from customers are normally 65% in the month of sale, 22% in the month following the sale, and 11% in the second month following the sale. It is expected that the balance be uncollectible. Fonsey pays for purchases in the month following the purchase. Cash disbursements for expenses other than merchandise purchases are expected to be $13,300 for May. Fonsey’s cash balance on May 1 was $21,500.
Required:
- Compute the expected cash collections during May.
- Compute the expected cash balance on May 31.
Question 4
Five years ago, Phil Coulson left his position at a large company to start Coulson Spy Solutions Co. (CSS), a software design and tracking company. CSS’s first product was a unique software package that seamlessly integrates networked PCs. Robust sales of this initial product permitted the company to begin development of other software products and to hire additional personnel. The staff at CSS quickly grew from three people working out of Phil’s basement to more than 70 individuals working in leased spaces at an industrial park. Continued growth led Coulson to hire seasoned marketing, distribution, and production managers and an experienced accountant.
Recently, Coulson decided that the company had become too large to run on an informal basis and that a formalized planning and control program centered around a budget was necessary. Coulson asked the accountant, Maria Hill, to work with him in developing the initial budget for CSS.
Coulson forecasted sales revenues based on his projections for both the market growth for the initial software and successful completion of new products. Hill used this data to construct the master budget for the company, which she then broke down into departmental budgets. Coulson and Hill met a number of times over a three-week period to hammer out the details of the budgets.
When Coulson and Hill were satisfied with their work, the various departmental budgets were distributed to the department managers with a cover letter explaining CSS’s new budgeting system. The letter requested everyone’s assistance in working together to achieve the budget objectives. Several of the department managers were displeased with how the budgeting process was undertaken. In discussing the situation among themselves, they felt that some of the budget projections were overly optimistic and not realistically attainable.
Required:
- How does the budgeting process Coulson and Hill used at CSS differ from recommended practice?
- What are the behavioural implications of the way Coulson and Hill went about preparing the master budget?
Question 1 (Total: 20 marks)
When analyzing the total variable overhead cost variance into both spending and efficiency variances, it is often assumed that direct labour hours is the sole cost driver.
Required:
- Explain if direct labour costs could ever be a better cost driver of variable overhead costs than direct labour hours.
- How is the standard variable overhead rate different from the standard labour rate in variance analysis? Please explain.
Question 2 (Total: 14 marks)
CLAW Corporation is a manufacturer of industrial equipment, located in Toronto, Ontario. CLAW has a standard costing system based on direct labour hours (DLHs) as the measure of activity. Data from the company’s flexible budget for manufacturing overhead are given below:
Denominator Level of Activity | 9,000 DLHs |
Overhead Costs at the Denominator Activity Level: | |
Variable Overhead Cost | $90,700 |
Fixed Overhead Cost | $102,800 |
The following data pertains to operations for the most recent period:
Actual Hours | 7,800 DLHs |
Standard Hours Allowed for the Actual Output | 7,765 DLHs |
Actual Total Variable Overhead Cost | $54,210 |
Actual Total Fixed Overhead Cost | $100,200 |
Required:
- What was the total predetermined overhead rate?
- How much overhead was applied to products during the period?
Question 3 (Total: 30 marks)
For the Win (FTW) Corporation uses a standard costing system in the creation of awards and trophies. The Manufacturing overhead costs are applied to products on the basis of machine time.
Required:
- Unfortunately, due to accounting glitches in FTW’s software, several numbers and labels have been omitted from the analysis of fixed overhead below. Supply the missing numbers and labels to help FTW out:
Actual Fixed Overhead Cost | Flexible Budget Overhead Cost | Fixed Overhead Cost Applied to Work in Process |
(a) | (b) | 302,100 MH x $1.08 = (c) |
Budget variance, $1,880 U | (d) | |
Total variance, $388 F | (e) |
- Next, assume that 6 minutes of machine time is standard per unit of production. How many units were actually produced in the situation above?
- Once again, assume that 6 minutes of machine time is standard per unit of production. How many units of production were assumed when the predetermined application rate for fixed overhead was established?
Question 4
Orville Company’s standard and actual costs per unit are provided below for the most recent period. During this time period 400 units were actually produced.
Standard | Actual | |
Materials: | ||
Standard: 2 metres at $1.50 per m. | $3.00 | |
Actual: 2.1 metres at $1.60 per m. | $3.36 | |
Direct labour: | ||
Standard: 1.5 hrs. at $6.00 per hr. | 9.00 | |
Actual: 1.4 hrs. at $6.50 per hr. | 9.10 | |
Variable overhead: | ||
Standard: 1.5 hrs. at $3.40 per hr. | 5.10 | |
Actual: 1.4 hrs. at $3.10 per hr. | 4.34 | |
Total unit cost | $17.19 | $16.80 |
For simplicity, assume there was no inventory of materials at the beginning or end of the period.
Required:
Given the information above, compute the following variances. Also indicate if the variances are favorable or unfavorable.
- Materials price variance
- Materials quantity variance
- Direct labour rate variance
- Direct labour efficiency variance
- Variable overhead spending variance
- Variable overhead efficiency variance
Question 1 (Total: 20 marks)
Best Brew Manufacturing Company has two Service Departments-Custodial Services and Maintenance-and three Production Departments-Brewing, Bottling, and Packaging. Best Brew allocates the cost of Custodial Services on the basis of square metres and Maintenance on the basis of labour hours. Budgeted operating data for the year just completed follow:
Service Departments | Operating Departments | ||||
Custodial | Maintenance | Brewing | Bottling | Packaging | |
Budgeted costs before allocation | $18,000 | $8,000 | $80,000 | $50,000 | $90,000 |
Square metres | 1,000 | 10,000 | 5,000 | 22,000 | 13,000 |
Labour-hours | – | – | 4,000 | 8,000 | 8,000 |
Required:
- Prepare a schedule, which allocates Service Department costs to the Production Departments by the direct method.
- Prepare a schedule, which allocates Service Department costs to the Production Departments by the step-down method, allocating Custodial Services first.
Question 2 (Total: 40 marks)
Tabulation Corporation manufactures and sells two types of electronic calculators: EL-520 W and EL-620 T. The following data was gathered from last month’s activities:
EL-520 W EL-620 T
Sales in units 5,000 3,000
Selling price per unit $50 $100
Variable production costs per unit $10 $26
Traceable fixed production costs $100,000 $150,000
Variable selling expenses per unit $5 $6
Traceable fixed selling expenses $5,000 $7,500
Allocated division administrative expenses $50,000 $60,000
Required:
- Prepare a segmented income statement in the contribution format for last month, showing both “Amount” and “Percent” columns for the company as a whole and for each model.
- Why might it be very difficult to calculate separate break-even sales for each model?
- Refer to the original data and, if necessary, the results of the segmented income statement prepared in part (1) above. Calculate the total break-even sales (in both units AND dollars) for last month, assuming that none of the fixed production costs and fixed selling expenses is traceable. Allocate the total break-even sales between the two models.
- Again, refer to the original data and, if necessary, the results of the segmented income statement prepared in part (1) above. Calculate the total break-even sales (in both units AND dollars) for last month, assuming that the “allocated” amounts of the company’s administrative expenses are actually traceable. Allocate the total break-even sales between the two models.
- How reasonable are the total break-even sales numbers calculated in parts (3) and (4) given the actual results for last month?
Question 3 (Total: 20 marks)
The following data is provided on behalf of Mittens Incorporated for last year appear below:
Mittens Incorporated | ||
Statements of Financial Position | ||
For the Year Ended June 2020 | ||
Beginning Balance | Ending Balance | |
Assets: | ||
Cash | $135,000 | $266,000 |
Accounts receivable | 225,000 | 475,000 |
Inventory | 314,000 | 394,000 |
Plant and equipment (net) | 940,000 | 860,000 |
Investment in Scarf Company | 104,000 | 101,000 |
Land (undeveloped) | 198,000 | 65,000 |
Total assets | $1,916,000 | $2,161,000 |
Liabilities and owners’ equity: | ||
Accounts payable | $88,000 | $119,000 |
Long-term debt | 585,000 | 665,000 |
Owners’ equity | 1,243,000 | 1,377,000 |
Total liabilities and owners’ equity | $1,916,000 | $2,161,000 |
Mittens Incorporated | ||
Income Statement | ||
June 2020 | ||
Sales | $4,644,000 | |
Less operating expenses | 4,291,000 | |
Net operating income | 353,000 | |
Less interest and taxes: | ||
Interest expense | $90,000 | |
Tax expense | 129,000 | 219,000 |
Operating Income | $134,000 |
The “Investment in Scarf Company” on the statement of financial position represents an investment in the stock of another company.
Required:
- Compute the company’s margin, turnover, and return on investment for last year.
- The Board of Directors of Mittens Company have set a minimum required return of 15%. What was the company’s residual income last year?
Question 4 (Total: 20 marks)
Heisenberg Corporation has a Moldings Division that does molding work of various types. The company’s Machine Products Division has asked the Moldings Division to provide it with 20,000 special moldings each year on a continuing basis. The special moldings would require $10 per unit in variable production costs. The Machine Products Division has a bid from an outside supplier of $29 per unit for the moldings.
In order to have time and space to produce the new moldings, the Moldings Division would have to cut back production of another molding: the Blue4, which it presently is producing. The Blue4 sells for $30 per unit, and requires $12 per unit in variable production costs. Boxing and shipping costs of the Blue4 are $4 per unit. Boxing and shipping costs for the new special molding would be only $1 per unit. The company is now producing and selling 100,000 units of the Blue4 each year. Production and sales of this molding would drop by 20% if the new molding is produced.
Required:
- What is the range of transfer prices within which both the divisions’ profits would increase as a result of agreeing to the transfer of 20,000 moldings per year from the Moldings Division to the Machine Products Division?
- Is it in the best interests of Heisenberg Corporation for this transfer to take place? Explain.
Question 1 (Total: 27 marks)
PEI Lighthouse Company makes 20,000 units per year of a specialty light used by lighthouses all around the world. The unit product cost of this part is computed as follows:
Direct Materials | $24.70 |
Direct Labour | $16.30 |
Variable Manufacturing Overhead | $2.30 |
Fixed Manufacturing Overhead | $13.40 |
Unit Product Cost | $56.70 |
An outside supplier has offered to sell the company the part that PEI Lighthouse Company needs for $51.80 a unit. If the company accepts this offer, the facilities now being used to make the part could be used to make more units of a product that is in high demand. The additional contribution margin on this other product would be $44,000 per year.
If the part were purchased from the outside supplier, all of the direct labour cost of the part would be avoided. However, $5.10 of the fixed manufacturing overhead cost that is being applied to the part would continue, even if the part were purchased from the outside supplier. This fixed manufacturing overhead cost would be applied to the company’s remaining products.
Required:
- How much of the unit product cost of $56.70 is relevant in the decision of whether to make or buy the part?
- What is the net total dollar advantage (disadvantage) of purchasing the part rather than making it?
- What is the maximum amount the company should be willing to pay an outside supplier per unit for the part if the supplier commits to supplying all 20,000 units required each year?
Question 2 (Total: 26 marks)
Cavendish Cheese Company makes three products within their single facility. Data concerning these products follow:
Products | |||
A | B | C | |
Selling price per unit | $67.90 | $57.70 | $43.90 |
Direct materials | $12.10 | $10.30 | $8.60 |
Direct labour | $14.10 | $8.00 | $6.80 |
Variable manufacturing overhead | $2.60 | $2.20 | $1.80 |
Variable selling cost per unit | $2.50 | $2.20 | $2.50 |
Mixing minutes per unit | 2.70 | 3.30 | 4.70 |
Monthly demand in units | 1,000 | 3,000 | 3,000 |
The mixing machines are potentially a constraint in the production facility. A total of 25,800 minutes are available per month on these machines.
Direct labour is a variable cost in this company.
Required:
- How many minutes of mixing machine time would be required to satisfy demand for all three products?
- How much of each product should be produced, rounded to the nearest whole unit, to maximize operating income?
- Up to how much should the company be willing to pay, rounded to the nearest whole cent, for one additional minute of mixing machine time if the company has made the best use of the existing mixing machine capacity?
Question 3 (Total: 21 marks)
Green Gables Company makes a product that has the following costs:
Per unit | Per year | |
Direct materials | $17.30 | |
Direct labour | 12.90 | |
Variable manufacturing overhead | 4.20 | |
Fixed manufacturing overhead | $916,800 | |
Variable SG&A expenses | 2.00 | |
Fixed SG&A expenses | 907,200 |
The company uses the absorption costing approach to cost-plus pricing. The pricing calculations are based on budgeted production and sales of 48,000 units per year.
The company has invested $360,000 in this product and expects a return on investment of 15%.
Required:
- Compute the markup on absorption cost.
- Compute the target selling price of the product using the absorption costing approach.
Question 4 (Total: 26 marks)
Cows Creamery Company makes two products from a common input. Joint processing costs up to the split-off point total $42,000 a year. The company allocates these costs to the joint products on the basis of their total sales values at the split-off point. Each product may be sold at the split-off point or processed further. Data concerning these products appear below:
Gooey Mooey | Wowie Cowie | Total | |
Allocated Joint processing costs | $22,000 | $19,600 | $41,600 |
Sales value at split-off point | $32,000 | $28,000 | $60,000 |
Costs of further processing | $11,600 | $25,300 | $36,900 |
Sales value after further processing | $40,800 | $54,200 | $95,000 |
Required:
- What is the net monetary advantage (disadvantage) of processing Gooey Mooey beyond the split-off point?
- What is the net monetary advantage (disadvantage) of processing Wowie Cowie beyond the split-off point?
- What is the minimum amount the company should accept for Gooey Mooey if it is to be sold at the split-off point?
- What is the minimum amount the company should accept for Wowie Cowie if it is to be sold at the split-off point?
When solving NPV questions, you may use excel, a calculator, the equation method or the following table. All methods are acceptable for solving these types of problems.
Question 1 (Total: 15 marks)
Takhini Hot Springs Company has an old machine that is fully depreciated but has a current salvage value of $5,000. The company wants to purchase a new machine that would cost $60,000 and have a five-year useful life and zero salvage value. Expected changes in annual revenues and expenses if the new machine is purchased are:
Increased revenues | $63,000 | |
Increased expenses: | ||
Salary of additional operator | $20,000 | |
Supplies | 9,000 | |
Depreciation | 12,000 | |
Maintenance | 4,000 | 45,000 |
Increased net income | $18,000 |
Required:
- What is the payback period on the new equipment?
- What is the simple rate of return on the new equipment?
Question 2 (Total: 30 marks)
Grey Mountain Summit Company is considering starting a small catering business in Whitehorse. The company would need to purchase a delivery van and equipment costing $125,000 to operate the business and another $60,000 for inventories and other working capital needs. Rent for the building to be used by the business will be $35,000 per year. Bree, a Business student at YU and part time employee at Grey Mountain, indicates that the annual cash inflow from the business will amount to $120,000. In addition to the building rent, annual cash outflow for operating costs will amount to $40,000. Bree wants to operate the catering business for only six years. She estimates that the equipment could be sold at that time for 4% of its original cost. Bree uses a 16% discount rate. (Ignore income taxes in this problem.)
Required:
- Would you advise Bree to make this investment? Use Net Present Value and Profitability analysis to support your decision.
Description | Years | Amount | 16% Factor | Present Value |
Van & equipment | 0 | ($125,000) | 1.000 | ($125,000) |
Working Capital | 0 | ($60,000) | 1.000 | ($60,000) |
Building rent | 1-6 | ($35,000) | 3.685 | ($128, 975) |
Net annual cash | ||||
Inflow | 1-6 | $80,000 | 3.685 | $294,800 |
Salvage values | ||||
Equipment | 6 | $5,000 | 0.410 | $2,050 |
Release of working | ||||
Capital | 6 | $60,000 | 0.410 | $24,600 |
Net Present Value | $7,475 |
Question 3: (Total: 10 marks)
Carcross Company is considering the purchase of a machine that promises to reduce operating costs by the same amount for every year of its six-year useful life. The machine will cost $83,150 and has no salvage value. The machine has a 20% internal rate of return. (Ignore income taxes in this problem.)
Required:
- What is the annual cost savings promised by the machine?
Question 4 (Total: 45 marks)
Consider each of the following situations independently.
- Annual cash inflows from two competing investment opportunities are given below. Each investment opportunity will require the same initial investment. Compute the present value of the cash inflows for each investment using a 20% discount rate.
Year | Investment X | Investment Y |
1 | $500 | 2,000 |
2 | 1,000 | 1,500 |
3 | 1,500 | 1,000 |
4 | 2,000 | 5,00 |
Total | $5,000 | $5,000 |
- At the end of three years, when you graduate from college, your father has promised to give you a used car that will cost $22,000. What lump sum must he invest now to have the $22,000 at the end of three years if he can invest money at
- 5%
- 8%
- Mark has just won the grand prize on the Wheel ‘n’ Deal quiz show. He has a choice between (a) receiving $400,000 immediately and (b) receiving $60,000 per year for eight years plus a lump sum of $150,000 at the end of the eight-year period. If Mark can get a return of 10% on his investments, which option would you recommend that he accept? (Use present value analysis, and show all computations.)
- You have just learned that you are a beneficiary in the will of your late Aunt Susan. The executrix of her estate has given you three options as to how you may receive your inheritance:
- You may receive $50,000 immediately.
- You may receive $80,000 at the end of six years.
- You may receive $12,000 at the end of each year for six years (a total of $72,000).
If you can invest money at a 12% return, which option would you prefer?