allon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from $166,900 to $198,400 Variable costs and their percentage elationship to sales are sales commissions 6%, advertising 5%, travel 4%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,300, depreciation on delivery equipment $6,600, and insurance on delivery equipment $1,000. Prepare a monthly selling expense flexible budget for each $10.500 increment of sales within the relevant range for the year ending December 31, 2020. (List variable costs before fixed costs) FALLON COMPANY Monthly Selling Expense Flexible Budget For the Year 2020

allon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from $166,900 to $198,400 Variable costs and their percentage elationship to sales are sales commissions 6%, advertising 5%, travel 4%, and delivery 2%. Fixed selling expenses will consist of sales salaries $35,300, depreciation on delivery equipment $6,600, and insurance on delivery equipment $1,000. Prepare a monthly selling expense flexible budget for each $10.500 increment of sales within the relevant range for the year ending December 31, 2020. (List variable costs before fixed costs) FALLON COMPANY Monthly Selling Expense Flexible Budget For the Year 2020

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter12: Activity-based Management

Section: Chapter Questions

Problem 4CE: Foy Company has a welding activity and wants to develop a flexible budget formula for the activity....

See similar textbooks

Similar questions

Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
TIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.
Lowell Manufacturing Inc. has a normal selling price of 20 per unit and has been selling 125,000 units per month. In November, Lowell Manufacturing decided to lower its price to 19 per unit expecting it can increase the units sold by 16%. a. Compute the normal revenue with a 20 selling price. b. Compute the planned revenue with a 19 selling price. c. Compute the actual revenue for November, assuming 135,000 units were sold in November at 19 per unit. d. Compute the revenue price variance, assuming 135,000 units were sold in November at 19 per unit. e. Compute the revenue volume variance, assuming 135,000 units were sold in November at 19 per unit. f. Analyze and interpret the lowering of the price to 19.
Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?
Aspen Enterprises makes award pins for various events. Budget information regarding the current period is: A fraternity with which Aspen has a long relationship approached Aspen with a special order for 6,000 pins at a price of $2.75 per pin. Variable costs will be the same as the current production, and the special order will not impact the rest of the companys orders. However, Aspen is operating at capacity and will incur an additional $5,000 in fixed manufacturing overhead if the order is accepted. Based on this information, what is the differential income (loss) associated with accepting the special order?
Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?
Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.
Uchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?