Question

In: Accounting

Question 3 30 marks Travel On Inc. sells luggage. They sell a duffle bag, a carry-on...

Question 3 30 marks Travel On Inc. sells luggage. They sell a duffle bag, a carry-on suitcase and a deluxe suitcase. The price and variable cost for each type of luggage is listed below. Price Variable Cost Duffle bag R100 R 25 Carry-on 180 40 Deluxe 300 120 The total fixed costs for Travel On Inc. equals R60,000. For every 8 duffle bags. Travel On Inc sells it sells 3 carry-on suitcases and 1 deluxe suitcase. PBA4807 - Accounting for managers Page 15 of 16 © UNISA Graduate School of Business Leadership Required: 1.) Calculate the package contribution margin. 2.) Calculate the break-even point in units for duffle bags, carry-on suitcases and deluxe suitcases. 3.) If Travel On Inc. has a target income for the coming year of R300,000, how many packages will the company have to sell? 4.) Based on your answer in Part C, prepare a contribution margin income statement for the coming year. 5.) What is the company’s margin of safety in packages?

Solutions

Expert Solution

Contribution Margin : The difference between the selling price and variable cost is considered as the contribution margin of the product.

Break-even Point : It is the point where neither profit is earned nor any loss incurred. In other words, the unit in sales or sales in amount where the total expense is equal to selling price of the product.

1. Computation of contribution margin

Contribution margin per unit = Selling price per unit - Variable cost per unit

Price Variable cost Contribution Margin per unit Sales Mix Package Contribution Margin
Duffle bag $100 $25 $75 8 $600
Carry-on $180 $40 $140 3 $420
Deluxe $300 $120   $180 1 $180
$1,200

2. Computation of break-even point in units

Duffle bag Carry-on Deluxe
Break-Even Point 800 units 150 units 50 units

Calculations:

Break-Even Point = Fixed Cost / Package Contribution Margin

= $60,000 / 1,200

= 50 packages

* 50 Package X Sales Mix

Sales Mix Break Even Point
Duffle bag 50 packages X 8 800 Duffle bag
Carry-on 50 packages X 3 150 Carry-on
Deluxe 50 packages X 1 50 Deluxe

3. How many will the company have to sell to earn a desired profit of $300,000.

Desired sales in unit = Fixed cost + Desired Profit / Package Contribution Margin

= $60,000 + $300,000 / 1,200

= 300 packages

Sales Mix Desired Sales in units
Duffle bag 300 packages X 8 2,400 Duffle bag
Carry-on 300 packages X 3 900 Carry-on
Deluxe 300 packages X 1 300 Deluxe

4. Contribution Margin Income Statement

Contribution Margin Income Statement
Particulars Amount
Sales Revenue $492,000*
Less: Variable Expenses $132,000**
Contribution Margin $360,000
Less: Fixed Expenses $60,000
Net Income $300,000

Notes:

Sales Revenue*

Selling Prince Units Sales Revenue
Duffle bag 100 2,400 $240,000
Carry-on 180 900 $162,000
Deluxe 300 300 $90,000
Total $492,000*

Variable Expenses**

Variable cost Units Sales Revenue
Duffle bag $25 2,400 $60,000
Carry-on $40 900 $36,000
Deluxe $120   300 $36,000
Total $132,000**

5. Margin of Safety

Margin of Safety is the difference between the budgeted sales unit or desired sales unit and the break-even sales in unit. It is considered as the safety net where the business safe from the any loss.

Margin of Safety = Budgeted Sales in unit - Break-Even Sales in unit

= 300 packages - 50 packages

= 250 packages


Related Solutions

Travel On Inc. sells luggage. They sell a duffle bag, a carry-on suitcase and a deluxe...
Travel On Inc. sells luggage. They sell a duffle bag, a carry-on suitcase and a deluxe suitcase. The price and variable cost for each type of luggage is listed below. Price Variable Cost Duffle bag $100 $ 25 Carry-on 180 40 Deluxe 300 120 ? The total fixed costs for Travel On Inc. equals $60,000. For every 8 duffle bags Travel On Inc sells it sells 3 carry-on suitcases and 1 deluxe suitcase. Required: Show your calculations! A.) Calculate the...
QUESTION 1 In order to determine the average weight of carry-on luggage by passengers in airplanes,...
QUESTION 1 In order to determine the average weight of carry-on luggage by passengers in airplanes, a sample of 36 pieces of carry-on luggage was weighed. The average weight was 22 pounds. Assume that we know the standard deviation of the population to be 7 pounds. a. Determine a 99% confidence interval estimate for the mean weight of the carry-on luggage. b. Determine a 95% confidence interval estimate for the mean weight of the carry-on luggage.
Question 3 (30 marks) John Lee is the manager in charge of the audit of the...
Question 3 John Lee is the manager in charge of the audit of the upcoming annual audit of Hing Fat Ltd, a new audit client. All the preliminary verbal discussions and enquiries among the auditors, the company, the predecessor auditor and all other necessary parties have been completed. John will supervise two audit assistants on the engagement and willvisit the client again before the audit eldwork begins. John has established an understanding with the Head of Internal Audit on the...
SECTION A (30 marks) This section consists of ONE (1) compulsory question QUESTION 1 (30 marks)...
SECTION A This section consists of ONE (1) compulsory question QUESTION 1 ABC Ltd is a wholesaler of furniture which has been in operation for ten years. It buys furniture from five major manufacturers and sells them to a range of customers. The company currently has a customer base of over 500 customers most of which are credit customers. The receivables balance comprises customers owing up to $2,000,000 to smaller balances of about $10,000, all with many different due dates...
QUESTION 3 (30 MARKS) a. „Unemployment is a bad omen for many families as well as...
QUESTION 3 a. „Unemployment is a bad omen for many families as well as the nation at large‟. Discuss the aforementioned statement. b. With the aid of diagrams, explain how fiscal and monetary policies can be used to deal with the problem of unemployment.
Question 3 (30 marks) a. (15 marks) The finance director of Hi-Quality Productions (Hi-Q) is reviewing...
Question 3 a. The finance director of Hi-Quality Productions (Hi-Q) is reviewing the working capital management of the company. He is particularly concerned about the laxity in the accounts receivable collection process. The current credit terms of Hi-Q require customers to settle their bills within 30 days, but its customers are taking an average of 60 days to pay their bills. In addition, out of the total sales of $30m per year, the company suffers bad debts of $900,000 per...
QUESTION 3 (14 marks) The end of ABC’s reporting period is 30 April 2018. During the...
QUESTION 3 The end of ABC’s reporting period is 30 April 2018. During the past two years, the following transactions transpired relating to a machine: On 15 June 2016 ABC orders a one-of-a-kind machine at a price of N$800 000 to manufacture extra small MP3 players and paid in cash. The machine was delivered to ABC’s factory on 28 July 2016 and was installed and ready for use on 1 August 2016. The first products were manufactured on 16 August...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of the trading year. You have been provided with the following information: Trading; January February March Sales in Units 50 000 units 55 000 units 60 000 units Sales are expected to increase to 75 000 units per month from 1 April as the company increases production capacity. The selling price for each unit has been set at N$90.00 per unit. All sales are on...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of...
QUESTION 3 30 MARKS   Namic Inclusive CC is currently preparing budgets for the three months of the trading year. You have been provided with the following information: Trading; January February March Sales in Units 50 000 units 55 000 units 60 000 units Sales are expected to increase to 75 000 units per month from 1 April as the company increases production capacity. The selling price for each unit has been set at N$90.00 per unit. All sales are on...
Question 3 30 marks Use the following information to answer questions 3.1 and 3.2 Rush &...
Question 3 30 marks Use the following information to answer questions 3.1 and 3.2 Rush & Reddy Pty Ltd The balance sheet taken from the company’s year-end financials is provided below: Assets Dec-31 2015 R Dec-31 2014 R Dec-31 2013 R Current Assets Cash 122,200 108,000 Accounts Receivable 45,000 35,000 37,000 Inventory 17,000 14,000 13,000 Other Current Assets 13,000 11,000 Total Current Assets 197,200 168,000 50,000 Long-term Assets Property, Plant & Equipment, net 1,489,800 50,000 Intangible Assets 422,500 450,000 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT