HI5017 Managerial Accounting Assignment Tutorial Questions Answers

pages Pages: 4word Words: 890

Question :

Assessment Task – Tutorial Questions

Unit Code: HI5017

Unit Name: Managerial Accounting Assignment: Tutorial Questions 

Weighting: 50%

Total Assignment Marks: 50 marks

Purpose: This assignment is designed to assess your level of knowledge of the key topics covered in this unit

Unit Learning Outcomes Assessed:

1. Synthesize and critically analyse information from various sources and provide recommendations to improve the operations of organisations through the application of management accounting techniques;
2. Critically evaluate the various approaches to performance measurement and control in various
types of organisations, and devise and evaluate indicators of performance.
3. Demonstrate the need for a balance between financial and non-financial information in decision making, control and performance evaluation applications of management accounting.
4. Analyse a company’s financial statements and/or management reports and identify the strengths
and weaknesses of the company and articulate these to the various stakeholders.

Description: Each week students were provided with three tutorial questions of varying degrees of difficulty. These tutorial questions are available in the Tutorial Folder for each week on Blackboard. The Interactive Tutorials are designed to assist students with the process, skills and knowledge to answer the provided tutorial questions. Your task is to answer a selection of tutorial questions and submit these answers in a single document.

The questions to be answered are:

Question 2 - Week 3 (7 marks)

Tik Tok Company manufactures customized coffee tables. The following relates to Job No. X10, an order for 150 coffee tables:

Direct materials used $22 800 Direct labour hours worked 600 Direct labour rate per hour $16.00 Machine hours used 400

Applied factory overhead rate per machine hour $30.00

Required:

  1. What is the total manufacturing cost for Job No. X10? (3 marks)
  2. Calculate the cost per coffee table for Job No. X10? (2 marks)
  3. List two uses of this unit cost information to the managers at Tik Tok Company. (2 marks)

Question 2 - Week 5 (11 marks)

TikTok Electronics manufactures an aluminium fibre tripod model “TRI-X” which sells for

$1,600. The production cost computed per unit under traditional costing for each model in 2019 was as follows:

Traditional Costing
TRIX
Direct Materials
$700
Direct Labour ($20/hour)
$120
Manufacturing overhead ($38 per DLH)
$228
Total per unit cost
$1, 048

In 2019, TikTok Electronics manufactured 26,000 units of TRI-X. Under traditional costing, the gross profit on TRI-X was $552 ($1,600-$1,048). Management is considering phasing out TRI- X as it has continuously failed to reach the gross profit target of $600. Before finalizing its decision, management asks TikTok Electronics management accountant to prepare and analysis using activity-based costing (ABC). The management accountant accumulates the following information about overhead for the year ended December 31, 2019.

Activity Cost Pools
Cost Drivers
Estimated Overhead
Expected Use of Cost Drivers
Purchasing
Number of orders
$1,200,000
40,000
Machine setups
Number of setups
900,000
18,000
Machining
Machine hours
4,800,000
120,000
Quality Control
Number of inspections
700,000
28,000

The cost drivers used:

Cost Drivers
TRI-X Product
Purchase orders
17,000
Machine setups
5,000
Machine hours
75,000
Inspections
11,000

Required:

  1. Calculate the activity rates for each of the overhead items using the four cost drivers. (3 marks)
  2. Using the rates in (1) determine the unit cost for TRI-X. (4 marks)
  3. Calculate the gross profit of each model of TRI-X based on ABC costings and recommend whether or not TRI-X should be discontinued. (4 marks)

Question 3 - Week 6 (11 marks)

A new company, is being established to manufacture and sell an electronic tracking device: the Trackit. The owners are excited about the future profits that the business will generate. They have forecast that sales will grow to 2,600 Trackits per month within five months and will be at that level for the remainder of the first year.

The owners will invest a total of $250,000 in cash on the first day of operations (that is the first day of July). They will also transfer non-current assets into the company.

Extracts from the company’s business plan are shown below.

Sales

The forecast sales for the first five months are:

Month
Trackits (units)
July
1,000
August
1,500
September
2,000
October
2,400
November
2,600

The selling price has been set at $140 per Trackit.

Sales receipts

Sales will be mainly through large retail outlets. The pattern for the receipt of payment is expected to be as follows:

Time of payment% of sales value

Immediately15 *

One month later25

Two months later40

Three months later15

The balance represents anticipated bad debts.

* A 4% discount will be given for immediate payment

Production

The budget production volumes in units are:

July
August
September
October
1,450
1,650
2,120
2,460

Variable production cost

The budgeted variable production cost is $90 per unit, comprising:

$

Direct materials
60
Direct labour
10
Variable production overheads
20
Total variable cost
90

Direct materials: Payment for purchases will be made in the month following receipt of materials. There will be no opening inventory of materials in July. It will be company policy to hold inventory at the end of each month equal to 20% of the following month’s production requirements.

Direct labour will be paid in the month in which the production occurs.

Variable production overheads: 65% will be paid in the month in which production occurs and the remainder will be paid one month later.

Fixed overhead costs

Fixed overheads are estimated at $840,000 per annum and are expected to be incurred in equal amounts each month. 60% of the fixed overhead costs will be paid in the month in which they are incurred and 15% in the following month. The balance represents depreciation of noncurrent assets.

Required:

  1. Prepare a cash receipts budget schedule for each of the first three months (July – September), including the total receipts per month. (3 marks)
  2. Prepare a material purchases budget schedule for each of the first three months (July – September), including the total purchases per month. (4 marks)
  3. Prepare a cash budget for the month of July. Include the owners’ cash

contributions (4 marks)

Perfumes Ltd has two divisions: the Perfume Division and the Bottle Division. The company is decentralised and each division is evaluated as a profit centre. The Bottle Division produces bottles that can be used by the Perfume Division. The Bottle Division's variable manufacturing cost per unit is $3.00 and shipping costs are $0.20 per unit. The Bottle Division's external sales price is $4.00 per unit. No shipping costs are incurred on sales to the Perfume Division. The Perfume Division can purchase similar bottles in the external market for $3.50.

The Bottle Division has sufficient capacity to meet all external market demands in addition to meeting the demands of the Perfume Division.

Required:

  1. Using the general rule, determine the minimum transfer price. (2 marks)
  2. Assume the Bottle Division has no excess capacity and can sell everything produced externally. Would the transfer price change? (2 marks)
  3. Assume the Bottle Division has no excess capacity and can sell everything produced externally. What is the maximum amount Perfume Division would be willing to pay for the bottles? (2 marks)
  4. When is it more appropriate to use market-based transfer price rather than cost-based transfer price? (1 mark)
  5. International Printer Machines (IPM) builds three computer printer models: Alpha, Beta, and Gamma. Information for these three products is as follows:


Alpha
Beta
Gamma
Total

Selling price per unit

$250

$400

$1 500


Variable cost per unit
$80
$200
$800


Expected unit sales (annual)
12,000
6,000
2,000
20,000
Sales mix
50 percent
40 percent
10 percent
100 percent

Total annual fixed costs are $5,000,000. Assume the sales mix remains the same at all levels of sales.

Required:

  1. Calculate the weighted average unit contribution margin, assuming a constant sales mix. (2 marks)
  2. How many units of each printer must be sold to break even? (3 marks)
  3. i) Explain what is margin of safety (1 mark)

ii) Calculate in sales units the margin of safety for IPM, assuming projected sales are 25,000 units? (1 mark)

SHOW YOUR WORKING

GEM Limited has a single product Flicks. The company normally produces and sells 80,000 units of Flicks each year at a price of $240 per unit. The company’s unit costs at this level of activity are as follow:

Direct material
$57.00
Direct labour
60.00
Variable manufacturing overhead
16.80
Fixed manufacturing overhead
30.00
Variable selling and administrative costs
10.20
Fixed selling and administrative costs
27.00
Total unit cost
$201.00

GEM has sufficient capacity to produce 100 000 units of Flicks a year without any increase in fixed manufacturing overhead.

Required:

  1. GEM has an opportunity to sell 10 000 units to an overseas customer. Import duties and other special costs associated with this order would total $42 000. The only selling costs that would be associated with the order would be a shipping cost of $9.00 per unit. What would be the minimum acceptable unit price for GEM to consider this order? (hint: GEM would not accept the order if it would reduce the company’s profit) (3 marks)
  2. The company has 200 units of Flicks on hand that were produced two months ago. Due to blemishes on the units, it will be impossible to sell these units at the normal price. If the company wishes to sell them through regular sales channels, what would be the relevant cost for setting the minimum price? Explain. (2 marks)
  3. “All future costs are relevant in decision making.” Do you agree? Explain. (2 marks)
Show More

Answer :

Question 1

In the present business scenario, it has been determined that financial manager are required to use several types of costing methods that can lead to identifying the values of the manufacturing process. On the other hand, these costs tend to influence the business either directly or indirectly to the growth and effectiveness of the firm (Ward, 2012). It represents the efficiency of manufacturing activity that can help the firm to maintain the potential productivity of each unit produced during the period. It consists of material, procedure, and techniques that might be changed to ensure that the firm wastes as low raw material as possible so that chances of additional costs could not be incurred by for the period. 

(a): According to the given case example, Tik Tok Company is engaged in manufacturing customized coffee tables with a related Job No X10. 

Direct cost of material: $22800

The direct labor hrs is mentioned in the case; hence it is essential to compute the cost of labor per day by using the formula: 

Direct labor: Labor hrs * Rate 

: 600hr*$16: $9600

On the other hand, material overhead cost is also need given in the case of producing table for the firm. Therefore, cost could be determined by using the below formula: 

Material overhead cost: Machine hr*rate

: 400hr*$30: $12000

Thus,

Total production cost: $22800+$9600+$12000

: $44400. 

(b): As per the given information related to the coffee table manufacturing, it has been seen that a cost of $150 has been planned for coffee table. Hence, it is an important decision to have actual cost of manufacturing 1 table for the order X10. Therefore, direct material cost of $22800 is been considered to compute the per unit cost of material. 

Per unit cost: $22800 /150: $152 tables 

Labour cost needed: $9600 / 150: $64

Overhead cost: $12000/150: $80

Hence, 1 coffee table: $152+$80+$64: $296.

(c) In the production process, a unit cost is known as total expenses required by a Tik Tok company to manufactured coffee tables and sell one unit of a particular product for the period. This accounting a measure tends to consists of all the fixed and variable cost related to the manufacturing of product and services (Parker, 2012). The cost allocated to a chosen units as well as generally computed as the cost over a period is been divided by the total number of items produced by the company. Therefore, two of the primary use of cost per units is mentioned underneath: 

  • Per units, the cost is said to be key indicators that could enhance the productivity of Tik Tok Company. It would help in measuring the effectiveness of the company. 
  • It discloses the actual cost and individual cost of a coffee table produced to incurred a profit for the period. 

Question 2

According to the given case example, the application of activity based costing is considered to determine the key activities that are associated to the Tik Tok electronic company. It happens to a specific model that tends to assign mainly on indirect cost into direct one as compare to the conventional cost (Fullerton,  Kennedy and Widener, 2013). However, it is taken into account to increase the better understanding of material overhead cost as well as other factors that are used to evaluate the cost related activities efficiently. Hence, it can be important to compute the actual cost incurred for the production one units of products for the period. 

(a): 

Activity cost pool
Estimated overhead 
Cost driver
Expected use of cost
Activity Rate
Purchasing
12,00,000
Number of orders
40,000
$30
Machine setups
9,00,000
Number of set-ups
18,000
$50 
Machining
48,00,000
Machine hr
1,20,000
$40
Quality control
7,00,000
Number of inspections
28,000
25

Note

  • Purchasing of material: 1200000/ 40000: 30
  • Machine set-up: 900000/ 18000: $50
  • Machining: 4800000 / 120 000: $40
  • Quality control: 700000 / 28000 :25

(b)

Cost drivers
TRI-X products
Total cost
Purchase orders
17000
510000
Machine set-ups
5000
250000
Machining
75000
3000000
Quality control
11000
275000
Total manufacturing cost 
 
4035000

Overhead cost per units: Total production cost / no. of units produced

: $4035000/ 26000 units 

: $155

(c)

Particular 
Units 
Amount 
Sales (26000)
1600
41600000
Less:
 
 
Direct material
700
18200000
Direct labour
120
3120000
Overhead cost
155
4030000
Total cost of production 
 
25350000
Gross margin  
 
16250000
Cost units income 
 
625

Suggestion

From the above computation, it has been examined that the strategy implemented by the Tik Tok Company to discontinue for TRI-X products is less in terms of gross profit. These could incur because the firm is taking into account as traditional methods of accounting due to which they are not been able to earn a sufficient profit for the period (Cadez and Guilding, 2012). The Tik Tok Company is capable of generating a desirable amount of profit $552 at the cost of $1048. Thus, it has been seen that with the use of modern Activity based system the firm can generate maximum profit as compare to the traditional approaches. Further, they would earn a reliable income on per units cost at $625 that is sufficient enough to deal with the short-term cash balance. Overall, it has been recommended that ABC costing system assist the managers to produce more profit with the concern income level. 

Question 3

For any business organization, it has been determined the budget tends to play an eminent role in overall cost and expenses management of the company. The company need to make a valuable estimation of total income and expenses that are going to be levied in the production of product and services. The total spending decision intends to allow an organization to analyze the actual capacity of the firm that can enough to manage the day to day operational activity efficiently (Hiebl,  2014). On the other hand, the benefits of using a budget can take management away from their short-term and regular administration of the business. The decision that is made by the management to track their financial goal, assist in organizing the spending, and make unexpected expenses plan to control the additional cost of the company. It has been analyzed that there is various type of budgets that are prepared by the organization to manage its operation effectively. Some of them are calculated accurately below: 

(a): Cash budget 

Particular 
July 
August 
September 
Receipts: 
 
 
 
Cash sales 
20160
30240
40320
Debtors 
0
35000
108500
Total cash 
20160
65240
148820


Particular 
July 
August 
September 
Sales in units 
1000
1500
2000
Total sales 
140000
210000
280000
Cash receipt (15%)
21000
31500
42000
less: 4% discount 
840
1260
1680
Cash available 
20160
30240
40320

Working note

Particular 
July 
August 
September 
Debtors receipts 
 
 
 
1 month 25%
0
35000
52500
2 month 40%
0
0
56000
Total 
0
35000
108500

(b): Material purchase budget 

Particular 
July units 
August (units) 
September (units)
Opening cash balance 
0
290
330
Production requirement
1450
1650
2120
Closing cash  (20% of manufacturing) 
290
330
424
Material cost 
1740
2270
2874
Per units cost
60
60
60
Total cost of material 
104400
136200
172440

(c): Cash budget 

Particular 
July 
Capital 
250000
Net cash receipts
20160
Total 
270160
Payment 
 
Material cost 
0
Direct labor cost 
10000
Overhead 
13000
Fixed cost 
42000
Total paid cash 
65000
Net cash 
205160

Working note: VC: 1000*20: 20000

: 20000*65%: 13000

Fixed cost: 70000*60%: 42000

Question 4

(a): In the accounting terms, a transfer price tends to be used to describe the real price that is charged for the related organization in a global transaction. These particular issues intend to arise in a situation a firm of multinational organization resident in various legislation transfer property to others. It allows for an effective establishment of a price for product and services those are exchanges between subsidiaries that are a vital part of the large firms (Merchant, 2012). A firm can compute the minimum acceptable transfer price as equal to the variable cost include an opportunity cost. As per the given case example, it has been seen that bottle division and perfume division is been followed in the firm. On an estimation, that bottle division is having a decent output to fulfil the market requirements. Hence, per unit cost will be $3 as a transfer price to take outside market benefits. 

Working note: As per the mentioned case, the bottle division would charge shipping cost worth $0.20, while the perfume division could not consist of any shipping prices. 

(b): As per the given case example, it has been analyzed that bottle division would not be related to extra ability to fulfil the actual need for perfume division. Hence, it can capable of selling their products into the external market. Moreover, in this situation, the transfer price would levy as other marginal costs that tend to incur a negative profit to the firm (Joshi and Li, 2016). The formula to compute the transfer pricing is Marginal cost + opportunity cost. Hence, it would be suggested that a $4 per unit cost is accountable to earn a profit for the company. 

(c) According to the case example, the actual cost price that is suitable to the perfume division is relatively less as the actual marginal cost of manufacturing the one units products in the external market. It can lead to generating a sufficient amount that can easily meet the demands of the customers. Thus, it is a tough challenge to determine the real price of perfume division that are produced for the period. Hence, the actual price would remain $3.5 per units. 

(d) Cost-based price is said to be an organization ability that is required to take into account to examine the actual cost in the starting phase of the production. On the other hand, market-based price tends to remain change as per the operational demands arises in the markets. Therefore, it has been identified that the overall outcome is computed as on the fair value of the products (Senftlechner and Hiebl, 2015). Thus, a full cost is applied as a transfer price that can generate desirable revenue to the firm. Bottle division incurred a profit of 0.80 per bottle, whereas the perfume division is liable to produce 0.5 per division income respectively. 

Question 5

(a): 

Particular 
Alpha 
Beta 
Gamma
Selling cost per units
10000
8000
2000
Contribution per units 
170
200
700
Total contribution 
1700000
1600000
1400000
  • Weighted average unit contribution margin: Total contribution / no of unit sold 
  • : 4700000/20000: $235. 
  • (b): Breakeven point 
Particulars
Alpha
Beta
Gamma
Total
units
10000
                8000
               2000
20000
SP per unit
250.00 
               400.00 
           1,500.00 
 
VC in units 
                80.00 
               200.00 
               800.00 
 
Contribution units 
            170.00 
              200.00 
               700.00 
 
Weight to each printer
              0.50
                0.40
                  0.10
 
Weight contribution per unit
             85.00 
               80.00 
               140.00 
             305.00 
Total Fixed cost
 
 
 
 $  5,000,000.00 
Breakeven point
 (5000000 / 305) 
                 21,277 
Breakeven point for each printer 
                 10,638 
                    8,511 
                    2,128 
 

(c) (i): Concept of margin of safety

Margin of safety: It happens to be an important different between the intrinsic value of an inventory and market price. In the case of a break-even point, the margin of safety is total output level that can lies before a firm reached to their level. It can be computed by taking into account the actual sales minus the break-even sales amount. 

(ii): calculation for projected 25000 units 

Particulars 25000u
Alpha
Beta
Gamma
Total
Breakeven point for each printer
                  10,638 
                    8,511 
                    2,128 
                 21,277 
Number of sold units
                  12500
                    10000
                      2500
                 25,000 
Difference ( Sales - BEP)
                    1,862 
                    1,489 
                       372 
                    3,723 
Margin of safety
                      0.18 
                      0.18 
                      0.17 
                      0.17 

Question 6

(a): Minimum acceptable unit cost for GEM

Minimum unit price: DM+ DL+ Overhead +selling overhead + Shipping cost+ Import duty

: 57+60+16.8+10.2+9+4.2:$157.20.

(b): Relevant minimum price for concern unit

According to the given scenario, if the damage is been realized in an inventory at low selling price, the expenses that are levied by the company for the sale of these stock can be managed accurately. Moreover, the scenario suggested that firm is able to generate a total amount of $10.20 per units over the variable expenses. Hence, the minimum SP for manufacturing 200 units could be considered as $2040.

(c): Recommended decision 

As per the given case example, it has been realized that the projected cost is taken into account of making future decision. These decisions might be based on the total cost and profit-making ability of an organization. Thus, the case a firm has liable to incurred a high cost that can be taken into account to generate profit is useful to predict the future revenue.