Question

In: Accounting

As part of the process of preparing the master budget for the coming year, you’ve been...

As part of the process of preparing the master budget for the coming year, you’ve been asked to perform what-if analyses, in the form of scenarios, on the original planning assumptions regarding Product A produced by your company. The following are the baseline planning data for the coming year for this product: Sales volume (annual, in units) 2,500 Selling price per unit $ 1,500 Variable cost per unit $ 1,000 Fixed costs (per year) $ 200,000 Required: 1. Based on the baseline planning data, what is the budgeted operating income for Product A for the coming year? 2. Determine the estimated operating income under each of the following scenarios (for each scenario you should report both the new budgeted operating income and the percentage change in operating income from the baseline budgeted result): a. Selling price per unit is 10% higher than planned, while fixed costs per year are also 10% higher than planned. b. Variable cost per unit is 5% higher than planned, while fixed costs are lower by this same percentage. c. Selling price per unit is 10% higher than planned, while volume is decreased by 8%.

Solutions

Expert Solution


Related Solutions

Freewheel is in the process of preparing its master budget for the six months ending December...
Freewheel is in the process of preparing its master budget for the six months ending December 19X2. The balance sheet for the year ended 30 June 19X2 is estimated to be as follows: Cost Deprec prov NBV Fixed assets 140.000 14.000 126.000 Current assets Stock 25.000 Trade debtors 24.600 Bank 3.000 Net current liabilities 52.600 Creditors Amount falling due within one year Trade creditors 25.000 Other creditors 9.000 34.000 Net current assets 18.600 Total assets less current liabilities 144.600 Capital...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: This will be the first year of operation for Okay Company. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted sales units...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: April May Sales ………………………………………………………… $150,000 $157,500 Merchandise purchases …………………………… 107,000 112,400 Operating expenses: Payroll ………………………………………………… 13,600 14,280 Advertising ………………………………………….. 5,400 5,700 Rent …………………………………………………….. 2,500 2,500 Depreciation ………………………………………… 7,500 7,500 End of April balances: Cash ……………………………………………………… 30,000 Bank loan payable ………………………………… 26,000 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50%...
Corporation is preparing its budget for the coming year. The first step is to plan for...
Corporation is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price $12 Waterways wants...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and...
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and asks for your assistance. The following costs and other data apply to bag production. Direct materials per bag 2.80 yard cotton at $3.80 per yard 1.10 yards canvas finish at $11.20 per yard Direct labor per bag 1.20 hour at $18.60 per hour Overhead per bag Indirect labor $ 1.30 Indirect materials 2.00 Power 2.20 Equipment costs 3.10 Building occupancy 2.70 Total overhead per...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to...
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Actual unit sates for November 113,500 Actual unit sales for December 103,100 Expected unit sales for January 114,000 Expected unit sales for February 113,500 Expected unit sales for March 116,000 Expected unit sales for April 126,000 Expected unit sales for May 138,500 Unit selling price...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 112,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 115,000 Expected unit sales for April 2020 124,000...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 114,000 Unit sales for December 2019 103,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 111,000 Expected unit sales for March 2020 116,000 Expected unit sales for April 2020 125,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT