Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales 18% of sales $6,000 per month plus 12% of sales $30,000 per month Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Prepare a flexible selling and administrative expenses budget for March for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 5 as a model.) Cloud Productivity Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending March 31 Total sales Variable cost: Sales commissions Advertising expense Miscellaneous administrative expense Customer support expenses Total variable cost $12,000 per month plus 20% of sales $31,000 per month Fixed cost: Miscellaneous administrative expense $400000 $500000 $600000 56,000 70,000 100000 Fixed cost: Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Total fixed cost Total selling and administrative expenses 1000000 000000

Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales 18% of sales $6,000 per month plus 12% of sales $30,000 per month Advertising expense Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Prepare a flexible selling and administrative expenses budget for March for sales volumes of $400,000, $500,000, and $600,000. (Use Exhibit 5 as a model.) Cloud Productivity Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending March 31 Total sales Variable cost: Sales commissions Advertising expense Miscellaneous administrative expense Customer support expenses Total variable cost $12,000 per month plus 20% of sales $31,000 per month Fixed cost: Miscellaneous administrative expense $400000 $500000 $600000 56,000 70,000 100000 Fixed cost: Miscellaneous administrative expense Office salaries expense Customer support expenses Research and development expense Total fixed cost Total selling and administrative expenses 1000000 000000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 3PB: TIB makes custom guitars and prepared the following sales budget for the second quarter It also has...

See similar textbooks

Similar questions

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.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
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.
Artic Camping Gears currently sells 35,000 units at $73 per unit. Its expenses are as follows: Management believes it can increase sales by 2,000 units for every $5 decrease in sales price. It also believes the additional sales will allow a decrease in direct material of $1 for each additional 2,000 units. Prepare a flexible budgeted income statement for 35,000-, 37,000-, and 39,000-unit sales.
Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per unit, direct labor of $3 per unit, and manufacturing overhead of $1 per unit. Fixed costs are $35,000. What would be the budgeted amounts for 20,000 and 25,000 units?
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?
Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)
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.
Before the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.
Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Judges Gavel uses this information when preparing their flexible budget: direct materials of $3 per unit, direct labor of $2.50 per unit, and manufacturing overhead of $1.25 per unit. Fixed costs are $49,000. What would be the budgeted amounts for 33,000 and 35,000 units?