Question

In: Accounting

Patrick and Bob started My My Baby two years ago to produce babyfurniture, such as:...

Patrick and Bob started My My Baby two years ago to produce baby furniture, such as: cribs, closets, changing tables etc. Bob, as the CFO, would like to start creating a budget for My My Baby for performance management purposes and cash flow assessments. This is the first time that My My Baby is going through a budget process, hence, Bob engaged you as their accountant to build the budget package for the year 2020. After your interview with Bob, you have collected the following information:

• Sales has been steadily increasing over the last two years. My My Baby has two key product lines: My Little Sunshine, the simple and classic line of baby cribs; and My Boss Baby, a high-end and premium line of baby cribs.

• Historical sales units for the last two years are list below. Bob expects 2020's sale to continue to increase steadily at the same rate.

In Units 2018 2019

My Little Sunshine 10,000 12,000

My Boss Baby 4,000 5,000

• My My Baby has a gross margin of 25% on gross sales for both lines. •

The selling price per unit for My Little Sunshine and My Boss Baby are $250 and $450 respectively.

• 20% of sales are for cash.

The remaining sales are credit sales. Collections are expected to be 50% within the year and 2% is uncollectible. No AR is expected to be outstanding at the end of 2019.

• Bob would like to always keep inventory equals to 20% of prior period sales on hand for each product line. The ending inventory of 2019 is expected to be 1,400 units for My Little Sunshine and 800 units for My Boos Baby.

• Other expenses budgeted by My My Baby are listed below:

Production Supervisor: 100,000

Depreciation - Office: 350,000

Rent - Warehouse: 500,000

Rent - Factory: 700,000

Marketing: 100,000

Factory Insurance: 98,000

Patrick and Bob's Salaries: 250,000

QA labour hours: 78,000

Factory Utilities: 100,000

Manufacturing supplies: 5,000

• All purchases and expenses are initially paid by credit. 90% of the annual expenses are expected to paid within the year.

• The tax rate for My My Baby is 27%.

1) Prepare Budgeted Operating Income Statement in good form with the following supporting schedules

A. Sales budget

B. Production budget

C. Factory overhead budget

D. Selling & Administrative Expense Budget

2) Patrick would like to develop a new line of changing tables of My My Baby. The expected up front investment is $2 million. Should My My Baby invest based on the current financial situation? (hint: cash flow) What is the risk of relying on this budget? What do you suggest for My My Baby to do to mitigate this?

Solutions

Expert Solution


Related Solutions

Patrick and Bob started My My Baby two years ago to produce baby furniture, such as:...
Patrick and Bob started My My Baby two years ago to produce baby furniture, such as: cribs, closets, changing tables etc. Bob, as the CFO, would like to start creating a budget for My My Baby for performance management purposes and cash flow assessments. This is the first time that My My Baby is going through a budget process, hence, Bob engaged you as their accountant to build the budget package for the year 2020. After your interview with Bob,...
Two years ago, on July 2nd, 2018 you started saving for a bike. At that time,...
Two years ago, on July 2nd, 2018 you started saving for a bike. At that time, you made your first of a sequence of 5 consecutive equal deposits to pay for the bike. Today, on July 2nd 2020, your dad is chipping in $500 to help you along your way to your goal of having $10,000 in four years time (which will be July 2nd, 2024). Today, you made your third, out of the five deposits. Figure out what the...
Dive In Company was started several years ago by two diving instructors. The company’s comparative balance...
Dive In Company was started several years ago by two diving instructors. The company’s comparative balance sheets and income statement are presented below. Current Year Previous Year Balance Sheet at December 31 Cash $ 4,460 $ 5,305 Accounts Receivable 1,900 950 Prepaid Rent 190 95 Total Assets $ 6,550 $ 6,350 Salaries and Wages Payable $ 800 $ 2,000 Common Stock 2,100 1,450 Retained Earnings 3,650 2,900 Total Liabilities and Stockholders’ Equity $ 6,550 $ 6,350 Income Statement Service Revenue...
Heads Up Company was started several years ago by two hockey instructors. The company’s comparative balance...
Heads Up Company was started several years ago by two hockey instructors. The company’s comparative balance sheets and income statement follow, along with additional information. Current Year Previous Year Balance Sheet at December 31 Cash $ 6,200 $ 3,800 Accounts Receivable 850 1,650 Equipment 4,950 4,500 Accumulated Depreciation—Equipment (1,400 ) (1,200 ) Total Assets $ 10,600 $ 8,750 Accounts Payable $ 550 $ 1,000 Salaries and Wages Payable 550 750 Note Payable (long-term) 1,700 500 Common Stock 4,500 4,500 Retained...
Heads Up Company was started several years ago by two hockey instructors. The company’s comparative balance...
Heads Up Company was started several years ago by two hockey instructors. The company’s comparative balance sheets and income statement follow, along with additional information. Current Year Previous Year Balance Sheet at December 31 Cash $ 6,060 $ 3,920 Accounts Receivable 830 1,610 Equipment 4,730 4,300 Accumulated Depreciation—Equipment (1,360 ) (1,180 ) $ 10,260 $ 8,650 Accounts Payable $ 770 $ 1,200 Salaries and Wages Payable 570 750 Note Payable (long-term) 1,600 500 Common Stock 4,300 4,300 Retained Earnings 3,020...
Part I – Original Mortgage: When Jane and Patrick Baker were “house hunting” five years ago,...
Part I – Original Mortgage: When Jane and Patrick Baker were “house hunting” five years ago, the fixed rate on a 30- year mortgage was 4.90% APR (monthly compounding) while the 15-year fixed rate was at 3.25% APR (monthly compounding). After walking through many homes, they finally reached a consensus and decided to buy a $500,000 home. The couple decided to put a 20% down payment in cash and take a loan for the remainder of the house price.   They...
Tracy started his sole proprietorship business two years ago and has never sold a §1231 asset....
Tracy started his sole proprietorship business two years ago and has never sold a §1231 asset. Tracy owned each of the assets for the entire 2 years he has been in business. In the current year, he sold the following business assets: Asset Original Cost Accumulated Depreciation Gain/Loss Desks $8,000 $2,000 ($2,000) Truck 12,000 6,000 (6,000) Equipment 18,000 12,000 13,500 Building 150,000 10,000 25,000Assuming Tracy’s marginal ordinary income tax rate is 30 percent, what is the character of Tracy’s gains...
Tuka Pty limited is a company based in Lusaka that was started 20 years ago by...
Tuka Pty limited is a company based in Lusaka that was started 20 years ago by two brothers. The company manufactures four similar products produced on the same production machinery. The company has been undergoing a drop in profits in recent years due to increased completion in the sector in which the company operates. At a recent board meeting, the board chairman suggested that the company may be losing business to its competitors due to inaccurate product cost information that...
You started a company 5 years ago by taking a loan of $100,000. The APR on...
You started a company 5 years ago by taking a loan of $100,000. The APR on the loan is 12%. You agreed to make fixed payments every month for 10 years. Today, your 60th payment is due and you decide to make a double payment. (You paid twice what you were paying each month). You will continue to make single payments to pay the rest of the loan. By how many months your loan shortened? (According to the contract you...
1. Restatetheargumentbelowusingstandardargumentform. None of my Hindu friends eat beef. When I visited India two years ago,...
1. Restatetheargumentbelowusingstandardargumentform. None of my Hindu friends eat beef. When I visited India two years ago, the Hindu restaurants I ate at in different parts of India did not serve beef. Therefore, it is very likely that all Hindus do not eat beef. P1: P2: C: 2. For the argument in question 1 decide whether it is a good or a bad argument. If you think it is deductive, then explain whether it is valid and sound; if you think...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT