Question

Carol's Crafts & Crock Pots has heard that a budget is a really good thing! You've...

Carol's Crafts & Crock Pots has heard that a budget is a really good thing!
You've been hired as their new managerial accountant, and have been called
into Carol's office to discuss it. You're shocked to see that Carol is actually
a man who is 6'-6" and a good 320#. He used to be known as "Carol the Crusher"
when played defensive end for Ohio State.
After recovering from the initial shock you start discussing the budget process with Carol.
You both decide that a forecast of three scenarios is a good starting point for
the budget planning.
Your task is to prepare three different scenarios for 2018 based on 2017 information and
the assumptions below.
Hint - you need to calculate the 2017 variable expense % to calculate variable % for
the 3 Scenarios.
Scenario #1 - Most-Likely
1. Sales increase by 15%
2. Fixed Costs remain the same.
3. Variable Costs % stay the same.
Scenario #2 - Best Case
1. Sales increase by 25%.
2. Fixed Costs for both Marketing and Operating go up 5%.
3. Variable Costs % stay the same.
Scenario #3 - Worst Case
1. Sales decrease by 5%
2. Fixed Costs remain the same.
3. Variable Costs % stay the same.
2016 information for the entire year:
Sales $4,000,000
Cost of Goods Sold $1,600,000
Gross Profit $2,400,000
Marketing Expenses
Variable $200,000
Fixed $100,000
Total Marketing Exp. $300,000
Operating Expenses
Variable $320,000
Fixed $400,000
Total Operating Exp. $720,000
Net Income $1,380,000

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Gina owns G’s Clay Pots, a manufacturer of clay planting pots of all different sizes. Gina...
Gina owns G’s Clay Pots, a manufacturer of clay planting pots of all different sizes. Gina is considering manufacturing a new product line: ceramic pots. He collects the following estimates for each ceramic pot: Sales price per pot = $28 Direct materials cost per pot = $5 Direct labor cost per pot = $3 Variable utilities costs per pot = $2 In addition to the costs above, Gina must develop a new production line for the ceramic pots. She can...
Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget....
Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2017, the following data are available. 1. Sales: 21,000 units quarter 1; 22,200 units quarter 2. 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3%. 3. Fixed costs per quarter: sales salaries $10,400, office salaries $6,100, depreciation $4,770, insurance $1,920, utilities $830, and repairs expense $620. 4. Unit selling price: $22....
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an...
Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 930,000 Direct labor 210,000 Machinery repairs (variable cost) 45,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($30,000 is variable) 180,000 Plant management salaries 200,000 1,865,000 Gross profit 1,285,000 Selling expenses Packaging 90,000 Shipping 105,000 Sales salary (fixed...
The following information is available for year 1 for Pepper Products:    Sales revenue (190,000 units)...
The following information is available for year 1 for Pepper Products:    Sales revenue (190,000 units) $ 3,800,000 Manufacturing costs Materials $ 224,000 Variable cash costs 190,000 Fixed cash costs 438,000 Depreciation (fixed) 1,336,000 Marketing and administrative costs Marketing (variable, cash) 565,000 Marketing depreciation 201,000 Administrative (fixed, cash) 684,000 Administrative depreciation 100,000 Total costs $ 3,738,000 Operating profits $ 62,000     All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Dancer Components: Sales revenue (220,000 units) $...
The following information is available for year 1 for Dancer Components: Sales revenue (220,000 units) $ 6,160,000 Manufacturing cost Materials $ 363,000 Variable cash cost 308,000 Fixed cash cost 708,000 Depreciation (fixed) 2,159,000 Marketing and administrative costs Marketing (variable, cash) 913,000 Marketing depreciation 323,000 Administrative (fixed, cash) 1,099,000 Administrative depreciation 161,000 Total costs $ 6,034,000 Operating profit $ 126,000 Variable marketing costs to change with unit volume. Administrative cash cost is expected to increase by 3 percent. Inventories will be...
Assume a project has a sales quantity of 7,500 units, ±3 percent and a sales price...
Assume a project has a sales quantity of 7,500 units, ±3 percent and a sales price of $60 a unit, ±2 percent. The expected variable cost per unit is $10, ±2 percent, and the expected fixed costs are $200,000, ±3 percent. The depreciation expense is $60,000 and the tax rate is 21 percent. What is the operating cash flow under the worst-case scenario?
Assume a project has a sales quantity of 7,400 units, ±6 percent and a sales price...
Assume a project has a sales quantity of 7,400 units, ±6 percent and a sales price of $59 a unit, ±3 percent. The expected variable cost per unit is $13, ±3 percent, and the expected fixed costs are $214,000, ±2 percent. The depreciation expense is $63,000 and the tax rate is 23 percent. What is the operating cash flow under the best-case scenario? (VERY URGENT !!!)
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the...
[The following information applies to the questions displayed below.] Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,150,000 Cost of goods sold Direct materials $ 930,000 Direct labor 225,000 Machinery repairs (variable cost) 60,000 Depreciation—Plant equipment (straight-line) 300,000 Utilities ($60,000 is variable) 180,000 Plant management salaries 210,000 1,905,000 Gross profit 1,245,000...
Sweet Ems makes candy bars for vending machines and sells them to vendors in cases of...
Sweet Ems makes candy bars for vending machines and sells them to vendors in cases of 30 bars. Although Sweet Ems makes a variety of candy, the cost differences are insignificant, and the cases all sell for the same price.Sweet Ems has a total capital investment of $13,000,000. It expects to produce and sell 550,000 cases of candy next year. Sweet Ems requires a 12 % target return on investment. Expected costs for next year are: Variable production costs $4.50...
Nappon Co. has two products named X and Y. The firm had the following master budget...
Nappon Co. has two products named X and Y. The firm had the following master budget for the year just completed: Product X Product Y Total Sales $260,000 360,000 $620,000 Variable Costs   156,000   180,000 336,000 Contribution Margin $104,000 $180,000 $284,000 Fixed Costs   130,000   108,000 238,000 Operating Income ($26,000) $72,000 $46,000 Selling Price per unit $130.00 $60.00 The following actual operating results were reported after the year was over: Product X Product Y Total Sales $202,500 $467,500 $670,000 Variable Costs   117,000...