Question
Jay Jones (known as JJ) is planning his new business for a fifth of November opening to customers. The business is structured as a private
Jay Jones (known as JJ) is planning his new business for a fifth of November opening to customers. The business is structured as a private company, which was registered by JJ for a cost of $600 in October. JJ is the only shareholder. He has set a target of $20,000 monthly operating profit for the company by the end of the first half year of operations. On last day of October, JJ will open the company’s bank account with $5,000 plus the money needed to purchase company assets.
The company will sell camping fridges that are packaged together with a solar blanket and battery for $1,100 per pack. JJ’s market research suggests these will be popular with grey nomads, young adventurers and day-tripper families. Forecast sales in units (packs) per month as follows: 40 in November; 50 in December; 70 in January; 90 in February; and 100 per month thereafter. Collections from customers are expected to be 30% in the month of sale, 50% in the month following sale and 20% in the second month following sale.
JJ’s company will have two inventory suppliers, one for the fridges and one for the solar blankets and batteries. One-year contracts with both suppliers include cost per unit (fridges
$400 and solar blanket with battery $500) for one monthly order of 40 units or more, free order delivery within one week, and invoices issued upon order with 21-day payment terms. JJ intends to take the full 21 days’ credit and order in the third week of each month, starting in October. Order quantity will be based on the sales forecast for the upcoming month.
Forecast monthly operating expenses for the company, starting in the opening month, are
$3,500 for a salaried employee, $2,100 for utilities, $2,000 for insurance, and $1,500 for marketing. These will be paid in the month incurred. In addition, quarterly rent payments in advance of $7,500 will need to be paid, starting on the first day of the opening month.
Several assets will be purchased by the company on the first day of the opening month. Office furniture will cost $15,000 and storeroom fixtures and fittings will cost $18,000. Both have an expected 10-year useful life. Computer equipment will cost $9,000 and have a 3-year useful life. The company will pay for these assets at the time of purchase. The assets will be depreciated using the straight-line method but have no expected salvage value.
Required
a CVP analysis (monthly figures) and a brief interpretation that also highlights any major implication(s) for the business;
- a monthly cash budget for May to October based on initial forecasts (below) and a brief interpretation that also highlights any major implication(s) for the business; and
- clarification of financing needs with suggested financing sources.
Step by Step Solution
3.44 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
a CVP Analysis Sales Revenue November 40 x 1100 44000 December 50 x 1100 55000 January 70 x 1100 77000 February 90 x 1100 99000 March onwards 100 x 1100 110000 Total Sales Revenue Monthly November 440...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started