Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a management consultant Refer to scenario and produce the following; Question Undertake a CVP analysis including monthly breakeven units and a brief interpretation

You are a management consultant Refer to scenario and produce the following;

Question

Undertake aCVP analysisincluding monthly breakeven units and a brief interpretation that alsohighlights any major implication(s) for the business. Interpretation and implication demonstrated providing an insight into the technique and its application in context.

Refer to scenario and calculations.

Scenario

Dev Patel has registered a new private company for his latest business venture. Dev is the only shareholder of the company. He intends opening to customers in the first week of October and he wants the business to begin making a monthly operating profit of $10,000 within the first six months of operation. In September, Dev intends to open a company bank account and deposit $20,000 plus the sum required to buy company non-current assets. These assets will be bought and paid for by the company on October 1 st. Dev expects furniture, fixtures and fittings to cost $30,000 and have a 10-year useful life, while computer equipment will cost $9,000 and have a 3-year useful life. All these assets will be depreciated using the straight-line method but none have any expected salvage value at the end of their useful lives.

Dev's business will sell candles to homeware stores for $10 each.Projected monthly sales in units (candles) are: 5,000 in October; 6,000 in November; 7,000 in December; 8,500 in January; and 10,000 each month after that. Forty per cent of customers are expected to pay in the month of sale, 50% in the month after sale, and the remainder in the second month after sale.

Negotiations with a supplier resulted in a one-year contract starting in September that specifies an $7.50 cost per unit for a monthly order of at least 5,000 units and payment to be made within 21-days of order.The contract also specifies order delivery within one week so Dev plans to order in the third week of each month, commencing in September, and pay at the end of the credit period. He will order the number of units that he expects the business to sell in the upcoming month.

Expected company operating expenses per month from October onwards, all of which will be paid for in the month incurred are: wages $6,000; utilities $2,000; insurance $4,000; and marketing $2,500. In addition, quarterly rent payments of $9,000 for an office and storeroom will be made in advance, commencing at the beginning of October.

Please check calculations if they are correct. Variable Cost (VC) = $7.50

Contribution Margin (CM) = Sales - Variables Cost

CM = $10 - $7.50 = $2.50

Fixed Cost (FC) = $14,500 + $3,000 (Rent)/Month FC = $17,500

Break Even Point (Units) = FC/CM $17,500/$2.50 = 7000 Units

Break Even Point ($) = FC/CM Ratio $17,500/(2.5/10) = $70,000.00

image text in transcribed
Budget Income Statement October November December January February March Sales 50,000.00 $ 60,000.00 $ 70,000.00 85,000.00 $ 100,000.00 $ 100,000.00 Cash Investment Salary Expense 6,000.00 $ 6,000.00 $ 6,000.00 6,000.00 6,000.00 6,000.00 Utilities in in in in in in in 2,000.00 2,000.00 S 2,000.00 2,000.00 $ 2,000.00 2,000.00 Insurance 4,000.00 $ 4,000.00 $ 4,000.00 4,000.00 4,000.00 4,000.00 Marketing 2,500.00 $ 2,500.00 $ 2,500.00 2,500.00 $ 2,500.00 2,500.00 Rent Expense 9,000.00 $ 9,000.00 $ Product Cost 87,500.00 $ 45,000.00 52,500.00 $ 63,750.00 $ 75,000.00 75,000.00 Purchase of non-current assets 39,000.00 $ Non-current assets October November December January February March Furniture, Fixtures & Fittings 30,000.00 $ - Computer Equipment 9,000.00 $ Total asset costs 9,000.00 $ Product Sales Schedule October November December January February March Sale (in units) 5000 600 7000 8500 1000 10000 Sales price/unit 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 Revenue 50,000.00 $ 60,000.00 $ 70,000.00 $ 85,000.00 $ 100,000.00 $ 100,000.00 Schedule of credit payments for sales (Collection) October November December January February March From current month 40% 20,000.00 $ 24,000.00 $ 28,000.00 34,000.00 $ 10,000.00 $ 40,000.00 From previous month 50% $ S 25,000.00 $ 30,000.00 35,000.00 $ 12,500.00 $ 50,000.00 From 2mths prior 10% $ 5,000.00 6,000.00 7,000.00 8,500.00 Total Payments Reciepted 20,000.00 $ 49,000.00 $ 63,000.00 75,000.00 $ 89,500.00 98,500.00 Product Purchases Schedule October November December January February March Order (in units) 6000 7000 8500 10000 1000 10000 Purchase cost/unit 7.50 $ 7.50 $ 7.50 $ 7.50 $ 7.50 $ 7.50 Purchase cost 45,000.00 $ 52,500.00 $ 63,750.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 Payment to supplier 37,500.00 $ 15,000.00 $ 2,500.00 $ 63,750.00 75,000.00 $ 75,000.00 Cash Budget Cash Receipts (Inflow) October November December January February March Receipts from Sales 20,000.00 $ 19,000.00 63,000.00 $ 75,000.00 9,500.00 $ 8,500.0 Total Receipts 20,000.00 $ 9,000.00 $ 3,000.00 $ 75,000.00 $ $9,500.00 $ 18,500.00 Cash Payments (Outflow) Salary Expense 6,000.00 6,000.00 $ 6,000.00 6,000.00 $ 6,000.00 $ 6,000.00 Utilities 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 Insurance 4,000.00 $ 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 Marketing 2,500.00 $ 2,500.00 $ 2,500.00 2,500.00 $ 2,500.00 2,500.00 Rent Expense 9,000.00 $ 9,000.00 $ Product Cost (Payment to Supplier) 37,500.00 $ 45,000.00 S 52,500.00 63,750.00 75,000.00 75,000.00 Purchase of assets 39,000.00 $ $ Total Cash Payments 100,000.00 $ 59,500.00 $ 67,000.00 $ 87,250.00 $ 89,500.00 9 9,500.00 Cash Surplus/Deficit 80,000.00 -$ 10,500.00 -$ 4,000.00 -$ 12,250.00 $ 9,000.00 Opening Cash Balance 59,000.00 -$ 21,000.00 -$ 31,500.00 -$ 35,500.00 -$ 47,750.00 -S 47,750.00 Closing Cash Balance 21,000.00 -$ 31,500.00 -$ 35,500.00 -$ 47,750.00 -$ 47,750.00 -$ 38,750.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles Volume 1

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

8th Canadian Edition

111950242X, 1-119-50242-5, 978-1119502425

More Books

Students also viewed these Accounting questions