Super Rich Business Person(SRBP) is opening a new merchandising company, COMPANY 2 .SRBP owns several companies, but COMPANY 1 is very similar to COMPANY 2 (market size and characteristics, product types, expected demand/supply, etc.). Because the two companies are so similar, SRBP is going to use COMPANY 1 as a source of estimated prices and costs for COMPANY 2. COMPANY 1 has been in operation for seven years, and it’s most recent Income Statement is presented below. Note that this income statement has been prepared especially for this purpose. SRBP’s accountant prepared it to show both cost function AND cost behavior.

COMPANY 1

Income Statement

For the year ended 20X6

(Total Units = 2,500)

Sales, Gross 275,000

Sales Discounts (2,000)

Sales Returns & Allowances (5,500) (7,500)

Sales, Net 267,500

Cost of Goods Sold (variable) (165,000)

Gross Profit 102,500

Variable Selling Expenses (19,250)

Variable Administrative Expenses (13,750)

Fixed Selling & Administrative Expenses (43,250) (76,250)

Net Income 26,250

A total of 2,500 units were sold at COMPANY 1 during the year. All sales accounts are variable in nature (Sales, Gross; Sales Discount; Sales Returns & Allowances; and Sales, Net). Based on the information given above, answer the following Cost-Volume-Profit Analysis questions:

1. SRBP will be using COMPANY 1 as an estimate for all information in COMPANY 2. Please list all revenues and expenses of COMPANY 1 (i.e., Sales and Expenses) as constants , whether the per unit or total amount (i.e., if an amount is constant as a per unit amount, calculate it as a per unit amount, if constant at the total amount, list it as a total amount).

2. Based on these estimates , what is the expected Contribution Margin per unit for COMPANY 2?

3. What is COMPANY 2’s expected Breakeven Point in units?

4. If COMPANY 2 wants an expected yearly profit of $50,000 , how many units would they need to sell?

Based on the information given above, complete the following Master Budget requirements for COMPANY 2 (again, using the numbers for COMPANY 1 as estimates):

5. Assume COMPANY 2 sells 3,450 units in 20X7, prepare the Sales ,Inventory Purchases , and Selling & Administration Expense budgets based on the following additional assumptions.

a. Prepare the Master Budget for 20X7 (i.e., only one unit amount, 3,450 units).

b. Use the Sales, Net price for budgeting purposes, this allows us to ignore the impact of Sales Discounts and Sales Returns & Allowances in the Master Budget.

c. Assume that 90% of all Sales, Net will be received in cash during the year, the remainder will be Accounts Receivable.

d. For Inventory Purchases , assume a Desired Ending Inventory amount of 400 units for 2017. Ignore discounts and return for the Master Budget.

e. Assume that 85% of all purchases will be paid in cash during the year , the remainder will be Accounts Payable.

f. All Selling (Marketing) and Administrative amounts can go in the same Expenditure Budget. This will include the variable amounts related to selling and administrative, as well as the fixed amounts.

Answer rating: 100% (QA)

1 List of Revenues and Expense per unit as well as total SRBP COMPANY 2 Marginal Income Statement For year ended Units 2500 Unit Total Net Sales 10700 ... View the full answer