Data for Hermann Corporation are shown below. Percent Per Unit of Sales $ 70 100% 49 70 $ 21 30% Selling price Variable expenses Contribution margin Fixed expenses are $74,000 per month and the company is selling 4.400 units per month. D Required: 1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $9,80 monthly sales volume increases by 100 units, and the total monthly sales increase by $7,000? 1-b. Should the advertising budget be increased?

Data for Hermann Corporation are shown below. Percent Per Unit of Sales $ 70 100% 49 70 $ 21 30% Selling price Variable expenses Contribution margin Fixed expenses are $74,000 per month and the company is selling 4.400 units per month. D Required: 1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $9,80 monthly sales volume increases by 100 units, and the total monthly sales increase by $7,000? 1-b. Should the advertising budget be increased?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

Wallace Industries has total contribution margin of $58,560 and net income of $24,400 for the month of April. Wallace expects sales volume to increase by 5% in May. What are the degree of operating leverage and the expected percent change in income for Wallace Industries? 0.42 and 2.2% 0.42and5% 2.4andl2% 2.Sandl3%
Olivian Company wants to earn 420,000 in net (after-tax) income next year. Its product is priced at 275 per unit. Product costs include: Variable selling expense is 14 per unit; fixed selling and administrative expense totals 290,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of 420,000. 2. Calculate the number of units that will yield operating income calculated in Requirement 1 above. (Round to the nearest unit.) 3. Prepare an income statement for Olivian Company for the coming year based on the number of units computed in Requirement 2. 4. What if Olivian had a 35 percent tax rate? Would the units sold to reach a 420,000 target net income be higher or lower than the units calculated in Requirement 3? Calculate the number of units needed at the new tax rate. (Round dollar amounts to the nearest dollar and unit amounts to the nearest unit.)
Starling Co. manufactures one product with a selling price of 18 and variable cost of 12. Starlings total annual fixed costs are 38,400. If operating income last year was 28,800, what was the number of units Starling sold? a. 4,800 b. 6,400 c. 5,600 d. 11,200
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Sales Needed to Earn Target Income Chillmax Company plans to sell 3,500 pairs of shoes at 60 each in the coming year. Variable cost is 35% of the sales price; contribution margin is 65% of the sales price. Total fixed cost equals 78,000 (includes fixed factory overhead and fixed selling and administrative expense). Required: 1. Calculate the sales revenue that Chillmax must make to earn operating income of 81,900 by using the point in sales equation. 2. Check your answer by preparing a contribution margin income statement based on the sales dollars calculated in Requirement 1.
Maple Enterprises sells a single product with a selling price of $75 and variable costs per unit of $30. The companys monthly fixed expenses are $22,500. What is the companys break-even point in units? What is the companys break-even point in dollars? Construct a contribution margin income statement for the month of September when they will sell 900 units. How many units will Maple need to sell in order to reach a target profit of $45,000? What dollar sales will Maple need in order to reach a target profit of $45,000? Construct a contribution margin income statement for Maple that reflects $150,000 in sales volume.
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.