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_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
- Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. Prepare a sales budget. Thunder Creek wants to finish each month with 20% of next month's sales in units. Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references. Enter all values as positive--without a minus sign--in row 18.) Hint: Beginning inventory for the period is equal to the ending inventory of the previous period.arrow_forwardSpartans Inc. sells Widgets. In January, Spartans forecasted it would sell 5,000 Widgets for 2023. Actual sales were 4,700 Widgets. Use the following information to estimate the Flexible Budget: Standard Costs: Actual Costs Materials - 1.3 pounds plastics 1.25 pounds plastic $3.45 per pound $3.60 per pound Labor 2.50 hours 2.80 hours $11.00 per hour $13.00 per hour Price $48.00 per Widget $52.00 per Widget FMOH $35,000 $42,000 Flexible Budget Materials Costs Flexible Budget Labor Costsarrow_forwardSafeNow sells its main product, ergonomic mouse pads, for $11 each. Its variable cost is $5.20 per pad. Fixed costs are $205,000 per month for volumes up to 65,000 pads. Above 65,000 pads, monthly fixed costs are $255,000. Prepare a monthly flexible budget for the product, showing sales revenue, variable costs, fixed costs, and operating income for volume levels of 40,000, 45,000, and 75,000 pads. SafeNow Flexible Budget Budget Amounts Per Unit 75.000 45,000 Units back @ # * 3 $ 40.000 IOI 4 5 6 4- & 7 LO T 9 O 44 ←arrow_forward
- ErgoNow sells its main product, ergonomic mouse pads, for $12 each. Its variable cost is $5.40 per pad. Fixed costs are $200,000 per month for volumes up to 65,000 pads. Above 65,000 pads, monthly fixed costs are $260,000. Prepare a monthly flexible budget for the product, showing sales revenue, variable costs, fixed costs, and operating income for volume levels of 35,000, 45,000, and 75,000 pads. ErgoNow Flexible Budget Budget Amounts Per Unit Units 35,000 45,000 75,000 (1) (2) (3) (4) (5) (1) Contribution Margin Fixed Costs Operating Income Sales Revenue Variable Costs (2) Contribution Margin Fixed Costs Operating Income Sales Revenue Variable Costs (3)…arrow_forwardOffice Plus sells its main product, ergonomic mouse pads, for $12 each. Its variable cost is $5.70 per pad. Fixed costs are $205,000 per month for volumes up to 65.000 pads. Above 65,000 pads, monthly fixed costs are $260,000. Prepare a monthly flexible budget for the product, showing sales revenue, variable costs, fixed costs, and operating income for volume levels of 35,000, 50,000, and 75,000 pads. + Units Office Plus Flexible Budget Budget Amounts Per Unit 35,000 50,000 () 75,000arrow_forwardHansell Company’s management wants to prepare budgets for one of its products, duraflex, for July 2010.The firm sells the product for $80 per unit and has the following expected sales (in units) for these monthsin 2010: April May June July August September5,000 5,400 5,500 6,000 7,000 8,000 The production process requires 4 pounds of dura-1000 and 2 pounds of flexplas. The firm’s policy is tomaintain an ending inventory each month equal to 10 percent of the following month’s budgeted sales, butin no case less than 500 units. All materials inventories are to be maintained at 5 percent of the productionneeds for the next month, but not to exceed 1,000 pounds. The firm expects all inventories at the end ofJune to be within the guidelines. The purchase department expects the materials to cost $1.25 per pound and$5.00 per pound for dura-1000 and flexplas, respectively.The production process requires direct labor at two skill levels. The rate for labor at the K102 level is $50per hour and…arrow_forward
- Please help me with show all calculation thankuarrow_forwardAfter completing their sales forecast, Fido Treats LLC has decided that it would like to create a production budget. The company's goal is to ensure that it will be able to produce enough dog treats to cover the sales that have been projected for the entire 1st quarter. Fido has projected the following sales: January 1,109 units, February 1242 units, March 1391 units, April 1405 units. The company has a policy of keeping 15% of the next month's projected sales on hand in their Finished Goods (FG) Inventory. Calculate the number of budgeted units that need to be produced for each and for the entire quarter.arrow_forwardDogarrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning