Garland Company expects to sell 600 wreaths in December 2018, but wants to plan for 100 more and 100 less than expected. The wreaths sell for $5.00 each and have variable costs of $2.00 each. Fixed costs are expected to be $500 for the month. Prepare a flexible budget for 500, 600, and 700 wreaths.
Prepare a flexible budget for Company G.
Explanation of Solution
Flexible overhead budget:
A flexible overhead budget is referred as a thorough plan for controlling the overhead cost, and is valid for the firm’s relevant range of activity. Based on the standard input the flexible overhead budget is measured. (Example: Machine hours)
Prepare a flexible budget for Company G as follows:
Company G Flexible Budget For the Month Ended December 31, 2018 | ||||
Particulars | Amount in ($) | |||
Net sales revenue (1) | $2,500 | $3,000 | $3,500 | |
Less: Variable costs (2) | 1,000 | 1,200 | 1,400 | |
Contribution Margin | 1,500 | 1,800 | 2,100 | |
Less: Fixed Costs | 500 | 500 | 500 | |
Operating Income | $1,000 | $1,300 | $1,600 |
Table (1)
Working note (1):
Compute the net sales revenue:
Particulars | For 500 units | For 600 units | For 700 units |
Number of Units (a) | 500 | 600 | 700 |
Selling costs per unit (b) | $5.0 | $5.0 | $5.0 |
Net sales revenue | $2,500 | $3,000 | $3,500 |
Table (2)
Working note (2):
Compute the variable costs:
Particulars | For 500 units | For 600 units | For 700 units |
Number of Units (a) | 500 | 600 | 700 |
Variable costs per unit (b) | $2.0 | $2.0 | $2.0 |
Variable factory overhead cost | $1,000 | $1,200 | $1,400 |
Table (3)
Want to see more full solutions like this?
Chapter 23 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Additional Business Textbook Solutions
Intermediate Accounting
Financial Accounting: Tools for Business Decision Making, 8th Edition
Principles Of Taxation For Business And Investment Planning 2020 Edition
Advanced Financial Accounting
Financial Accounting (11th Edition)
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
- 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?arrow_forwardLovely Wedding printing is budgeting sales of 32,000 units and already has 4,000 in beginning inventory. How many units must be produced to also meet the 6,000 units required in ending inventory?arrow_forwardShalimar 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.arrow_forward
- 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.arrow_forwardThe sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.arrow_forwardPlay-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forward
- 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.arrow_forwardNozama.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.arrow_forwardCold 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?arrow_forward
- One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.arrow_forwardTIB 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.arrow_forwardCrescent Company produces stuffed toy animals; one of these is Arabeau the Cow. Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and eight ounces of polyfiberfill. Fabric costs 3.50 per yard and polyfiberfill is 0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: Inventory policy requires that sufficient fabric be in ending monthly inventory to satisfy 20 percent of the following months production needs and sufficient polyfiberfill be in inventory to satisfy 40 percent of the following months production needs. Inventory of fabric and polyfiberfill at the beginning of October equals exactly the amount needed to satisfy the inventory policy. Each Arabeau produced requires (on average) 0.10 direct labor hour. The average cost of direct labor is 15 per hour. Required: 1. Prepare a direct materials purchases budget of fabric for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 2. Prepare a direct materials purchases budget of polyfiberfill for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 3. Prepare a direct labor budget for the last quarter of the year showing the hours needed and the direct labor cost for each month and for the quarter in total.arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning