Please help me to solve this problem Crane Corporation's master budget for the year is shown below:Sales (61,900 units)Cost of goods sold:Direct materialsDirect laborOverhead (variable overhead applied at 45% ofdirect labor cost)Gross profitSelling expenses:Sales commissions (all variable)Rent (all fixed)Insurance (all short-term fixed)General expenses:Salaries (all short-term fixed)Rent (all short-term fixed)Depreciation (all short-term fixed)Operating incomeRequired 2SalesLess: Cost of goods sold:Direct materialsDirect laborRequired:1. During the year, the company manufactured and sold 56,900 units of product. Prepare a flexible budget for this level of output.2. Now suppose that the actual level of output was 66,900 units. Prepare a flexible budget for this output level.CRANE CORPORATIONFlexible BudgetManufacturing overhead:VariableFixedGross profitLess: Operating expenses:Selling expenses:Complete this question by entering your answers in the tabs below.Required 1During the year, the company manufactured and sold 56,900 units of product. Prepare a flexible budget for this level ofoutput. (Do not round intermediate calculations.)Sales commissionsRentInsuranceGeneral expenses:SalariesRentDepreciationOperating income$ 191,890495,200259,000$$ 168,36859,00049,000$101,50086,50069,000< Required 1$ 2,228,400946,090$ 1,282,31000533,368$ 748,94200Required 2 > Required 1 Required 2Now suppose that the actual level of output was 66,900 units. Prepare a flexible budget for this output level. (Do not roundintermediate calculations.)SalesLess: Cost of goods sold:Direct materialsDirect laborCRANE CORPORATIONFlexible BudgetManufacturing overhead:VariableFixedGross profitLess: Operating expenses:Selling expenses:Sales commissionsRentInsuranceGeneral expenses:SalariesRentDepreciationOperating income$$< Required 10000Required 2 >

The flexible budget is prepared based on the standard rate and actual units of production. The…

Crane Corporation's master budget for the year is shown below: Sales (61,900 units) Cost of goods sold: Direct materials Direct labor Overhead (variable overhead applied at 45% of direct labor cost) Gross profit Selling expenses: Sales commissions (all variable) Rent (all fixed) Insurance (all short-term fixed) General expenses: Salaries (all short-term fixed) Rent (all short-term fixed) Depreciation (all short-term fixed) Operating income $ 191,890 495,200 259,000 $ 168,368 59,000 49,000 101,500 86,500 69,000 $ 2,228,400 946,090 $ 1,282,310 533,368 $ 748,942 Required: 1. During the year, the company manufactured and sold 56.900 units of product. Prepare a flexible budget for this level of out 2. Now suppose that the actual level of output was 66,900 units. Prepare a flexible budget for this output level.

Crane Corporation's master budget for the year is shown below: Sales (61,900 units) Cost of goods sold: Direct materials Direct labor Overhead (variable overhead applied at 45% of direct labor cost) Gross profit Selling expenses: Sales commissions (all variable) Rent (all fixed) Insurance (all short-term fixed) General expenses: Salaries (all short-term fixed) Rent (all short-term fixed) Depreciation (all short-term fixed) Operating income $ 191,890 495,200 259,000 $ 168,368 59,000 49,000 101,500 86,500 69,000 $ 2,228,400 946,090 $ 1,282,310 533,368 $ 748,942 Required: 1. During the year, the company manufactured and sold 56.900 units of product. Prepare a flexible budget for this level of out 2. Now suppose that the actual level of output was 66,900 units. Prepare a flexible budget for this output level.

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

At the beginning of the period, the Fabricating Department budgeted direct labor of 72,000 and equipment depreciation of 18,500 for 2,400 hours of production. The department actually completed 2,350 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
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.
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.
Performance Report Based on Budgeted and Actual Levels of Production Balboa Company budgeted production of 4,500 units with the following amounts: At the end of the year, Balboa had the following actual costs for production of 4,700 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,500 budgeted units. 2. Prepare a performance report using a budget based on expected (budgeted) production of 4,500 units. 3. Prepare a performance report using a budget based on the actual level of production of 4,700 units.
The fixed overhead budgeted for Ranier Industries at an expected capacity of 500,000 units is 1,500,000. Variable costing is used internally, and the net income is adjusted to an absorption costing net income at year-end. Data collected over the last three years show the following: Determine the adjustment each year to convert the variable costing income to absorption costing net income. Compute the absorption costing net income for each year.
Using the provided budgeted information for production of 10,000 and 15,000 units, prepare a flexible budget for 17,000 units.
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.
Prepare a flexible budgeted income statement for 47,000 units using the following information from a static budget for 45,000 units:
Adam Corporation manufactures computer tables and has the following budgeted indirect manufacturing cost information for the next year: If Adam uses the step-down (sequential) method, beginning with the Maintenance Department, to allocate support department costs to production departments, the total overhead (rounded to the nearest dollar) for the Machining Department to allocate to its products would be: a. 407,500. b. 422,750. c. 442,053. d. 445,000.
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: At the end of the year, Bowling had the following actual costs for production of 3,800 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,000 budgeted units. 2. Prepare a performance report using a budget based on expected production of 4,000 units. 3. Prepare a performance report using a budget based on the actual level of production of 3,800 units.
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?