Please do not give solution in image format thanku Fixed BudgetSales (14,000 units $204 per unit)CostsDirect materialsDirect laborIndirect materialsSupervisor salarySales commissionsShippingAdministrative salariesDepreciation-office equipmentInsuranceOffice rentIncome1. Compute total variable cost per unit.2. Compute total fixed costs.3. Prepare a flexible budget at activity levels of 12,000 units and 16,000 units.Complete this question by entering your answers in the tabs below.2,856,000322,000588,000378,000122,000112,000210,000172,000142,000112,000122,000576,000Required 1 Required 2Required 3Prepare a flexible budget at activity levels of 12,000 units and 16,000 units.TEMPO COMPANYSalesVariable costsDirect laborFlexible BudgetVariable Amount Total FixedCostper Unit115.00$42.00$670,000 00Flexible Budget forUnits Sales Unit Sales ofof 12,00016,000$2,448,000 $3,264,000

The variable cost per unit remains constant for every production level. The fixed costs in total…

Sales (14,000 units $204 per unit) Costs Direct materials Direct labor Indirect materials Supervisor salary Sales commissions Shipping Administrative salaries Depreciation-office equipment Insurance office rent Income 2,8 322,000 588,000 378,000 122,000 112,000 210,000 172,000 142,000 112,000 122,000 576,000 1. Compute total variable cost per unit. 2. Compute total fixed costs. 3. Prepare a flexible budget at activity levels of 12,000 units and 16,000 units.

Sales (14,000 units $204 per unit) Costs Direct materials Direct labor Indirect materials Supervisor salary Sales commissions Shipping Administrative salaries Depreciation-office equipment Insurance office rent Income 2,8 322,000 588,000 378,000 122,000 112,000 210,000 172,000 142,000 112,000 122,000 576,000 1. Compute total variable cost per unit. 2. Compute total fixed costs. 3. Prepare a flexible budget at activity levels of 12,000 units and 16,000 units.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 7CE: Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced...

See similar textbooks

Similar questions

Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
Howard Cooper, the president of Campbell Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour $ 85.00 Labor cost 37.00 Overhead cost 7.10 Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative 3.80 $522,000 142,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 45,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Campbell charges customers $80 per hour, the firm can achieve 50,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…
Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales). Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $ 67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $ 100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the…
The controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…
4. Use the following terms in preparing the budget: Insurance Maintenance Utilities Depreciation Expense Sales Commissions Depreciation Indirect Material Maintenance Salaries Indirect Labor Supervisory Salaries Sales Salaries Insurance Expense Spree Party Lights overhead expenses are: Indirect material, pounds per unit 0.25 Indirect material, cost per pound $ 2 Indirect labor hours 1 Indirect labor rate per hour $16.50 Variable maintenance per unit $0.75 Variable utilities per unit $0.20 Supervisor salaries $10,000 Maintenance salaries $9,000 Insurance $3,000 Depreciation $1,500 PLEASE NOTE: All dollar amounts are rounded to whole dollars and shown…
Required: a) Using Activity Based Costing, calculate the rate for each cost driver. b) Using activity based budgeting, prepare a budgeted yearly operating statement for Aero3D Ltd. Show the following separately, within the statement. i. The budgeted output for each product per year; ii. The contribution to profits for each product and in total before charging activity based costs; iii. The profit for each product and in total after charging activity based costs but before charging core costs (non-activity based costs); iv. The total profit after charging core based costs.
The Bakery Department of Culbert Dessert Corporation has submitted the following forecast of fruit pies to be produced by quarter for the upcoming fiscal year. Units to be produced First Quarter 9,300 Second Third Quarter Quarter 12,300 10,300 Units to be produced Direct labour time per unit (hours) Total direct labour-hours needed Direct labour cost per hour Total direct labour cost Each unit requires 0.40 direct labour-hours, and direct labour-hour workers are paid $9.00 per hour. In addition, the variable manufacturing overhead rate is $1.00 per direct labour-hour. The fixed manufacturing overhead is $26,250 per quarter. The only non-cash element of manufacturing overhead is depreciation, which is $7,650 per quarter. Required: 1. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecast number of units produced. Fourth Quarter 14,300 Culbert…
Q4: Use the following terms in preparing the budget: Insurance Maintenance Utilities Depreciation Expense Sales Commissions Depreciation Indirect Material Maintenance Salaries Indirect Labor Supervisory Salaries Sales Salaries Insurance Expense Spree Party Lights overhead expenses are: PLEASE NOTE: All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Using the terms and the information above, prepare a manufacturing overhead budget if the number of units to produce for January, February, and March are 2,500, 3,000, and 2,700, respectively (use the format shown in the textbook): Spree Party Lights Manufacturing Overhead Budget For the Quarter Ending March, 2019 Jan. Feb. Mar. Units to Produce 2,500 3,000 2,700 Variable Costs: Total Variable Manufacturing Costs Fixed Costs: Total Fixed Manufacturing Costs…
The Bakery Department of Culbert Dessert Corporation has submitted the following forecast of fruit pies to be produced by quarter for the upcoming fiscal year. First Second Third Fourth Quarter 8,300 Quarter Quarter 9,300 Quarter 13,300 Units to be produced 11,300 Each unit requires 0.60 direct labour-hours, and direct labour-hour workers are paid $9.00 per hour. In addition, the variable manufacturing overhead rate is $1.50 per direct labour-hour. The fixed manufacturing overhead is $23,750 per quarter. The only non-cash element of manufacturing overhead is depreciation, which is $7,150 per quarter. Required: 1. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecast number of units produced.
x Thomas Co. provides the following fixed budget data for the year: Sales (20,000 units) Cost of sales: Direct materials Direct labor Variable overhead Fixed overhead Gross profit Operating expenses: Fixed Variable Income from operations The company's actual activity for the Sales (21,000 units) Cost of goods sold: Direct materials Direct labor Variable overhead Fixed overhead Gross profit Operating expenses: Fixed Variable Income from operations F3 $200,000 160.000 60,000 80,000 $ 12,000 40.000 year follows: $231.000 168,000 73.500 77.500 12.000 39.500 F6 $600,000 500,000 $100,000 52.000 $ 48,000 $651,000 550.000 $101.000 51.500 $49.500 F7 F8
Panther Corporation appeared to be experiencing a good year. Sales in the first quarter were one-third ahead of last year, and the sales department predicted that this rate would continue throughout the entire year. The controller asked Janet Nomura, a summer accounting intern, to prepare a draft forecast for the year and to analyze the differences from last year's results. She based the forecast on actual results obtained in the first quarter plus the expected costs of production to be completed in the remainder of the year. She worked with various department heads (production, sales, and so on) to get the necessary information. The results of these efforts follow: PANTHER CORPORATION Expected Account Balances for December 31, Year 2 Cash 6,500 Accounts receivable 337,000 Inventory (January 1, Year 2) Plant and equipment Accumulated depreciation Accounts payable Notes payable (due within one year) Accrued payables 240,000 605,000 $ 181,000 197,000 217,000 110,000 Common stock 450,000…