do not give solution in image Exercise 21-5 (Algo) Preparing flexible budget performance report LO P1Nina Company prepared the following fixed budget for July using 7,520 units for budgeted sales. Actual sales were 7,220 units andactual costs are shown below.For Month Ended July 31SalesVariable costsDirect materialsDirect laborIndirect materialsSales commissionsTotal variable costsContribution marginFixed costsDepreciation MachinerySupervisor salaryInsuranceDepreciation Office equipmentAdministrative salariesTotal fixed costsIncomeFor Month Ended July 31SalesVariable costsDirect materialsDirect laborIndirect materialsSales commissionsTotal Variable CostsContribution marginFixed costsDepreciation MachinerySupervisory salaryInsuranceDepreciation Office equipmentAdministrative salariesTotal Fixed CostsFixed BudgetVariableAmountper Unit$ 100Income351541165$ 35Total FixedCost$ 68,39040,61010,0307,42033,900$ 160,350Prepare a flexible budget performance report for July at activity level of 7,220 units. Show variances between budgeted and actualamounts. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.)Fixed Budget(7,520 units)$ 752,0000030,08082,720488,800$ 263,200NINA COMPANYFlexible Budget Performance ReportFlexibleActualBudgetResults(7,220 units) (7,220 units)263,200112,80068,39040,61010,0307,42033,900160,350$ 102,8500Actual Results(7,220 units)$ 738,970Variances267,520109,90028,28078,610484,310$ 254,66068,39041,72010,0307,42029,880157,440$ 97,220Favorable/Unfavorable

A flexible budget is a budget that is prepared for different levels of activity or capacity…

Nina Company prepared the following fixed budget for July using 7,520 units for budgeted sales. Actual sales were 7,220 units and actual costs are shown below. For Month Ended July 31 Sales Variable costs Direct materials Direct labor Indirect materials Sales commissions Total variable costs Contribution margin Fixed costs Depreciation-Machinery Fixed Budget Variable Amount per Unit $ 100 35 186135 $ 35 Total Fixed Cost $ 68,390 Fixed Budget (7,520 units) $ 752,000 263,200 112,800 30,080 82,720 488,800 $ 263,200 68,390 Actual Results (7,220 units) $ 738,970 267,520 109,900 28,280 78,610 484,310 $ 254,660 68,398

Nina Company prepared the following fixed budget for July using 7,520 units for budgeted sales. Actual sales were 7,220 units and actual costs are shown below. For Month Ended July 31 Sales Variable costs Direct materials Direct labor Indirect materials Sales commissions Total variable costs Contribution margin Fixed costs Depreciation-Machinery Fixed Budget Variable Amount per Unit $ 100 35 186135 $ 35 Total Fixed Cost $ 68,390 Fixed Budget (7,520 units) $ 752,000 263,200 112,800 30,080 82,720 488,800 $ 263,200 68,390 Actual Results (7,220 units) $ 738,970 267,520 109,900 28,280 78,610 484,310 $ 254,660 68,398

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter23: Flexible Budgeting (flexbud)

Section: Chapter Questions

Problem 4R

See similar textbooks

Similar questions

Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
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.
Determining Budgeted Overhead The overhead application rate for a company is 10 per unit, made up of 6 per unit of fixed overhead and 4 per unit of variable overhead. Normal capacity is 10,000 units. In one month there was a favorable flexible budget variance of 2,500. Actual overhead for the month was 110,000 and actual units produced were 13,125. Based on this information, determine the amount of the budgeted overhead for the actual level of production.
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.
Flexible budget for factory overhead Presented below are the monthly factory overhead cost budget (at normal capacity of 5,000 units or 20,000 direct labor hours) and the production and cost data for a month. The predetermined overhead rate is based on normal capacity. Required: 1. Assuming that variable costs will vary in direct proportion to the change in volume, prepare a flexible budget for production levels of 80%, 90%, and 110% of normal capacity. Also determine the predetermined factory overhead rate at each level of volume in both units and direct labor hours. 2. Prepare a flexible budget for production levels of 80%, 90%, and 110%, assuming that variable costs will vary in direct proportion to the change in volume, but with the following exceptions. (Hint: Set up a third category for semi-variable expenses.) a. At 110% of capacity, another supervisor will be needed at a salary of 24,000 annually. b. At 80% of capacity, the repairs expense will drop to one-half of the amount at 100% capacity. c. At 80% of capacity, one part-time maintenance worker, earning 10,000 a year, will be laid off. d. At 110% of capacity, a machine not normally in use and on which no depreciation is normally recorded will be used in production. Its cost was 12,000, it has a 10-year life, and straight-line depreciation will be taken.
Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-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.
Flexible Budget for Various Levels of Production Budgeted amounts for the year: Required: 1. Prepare a flexible budget for 3,500, 4,000, and 4,500 units. 2. CONCEPTUAL CONNECTION Calculate the unit cost at 3,500, 4,000, and 4,500 units. (Note: Round unit costs to the nearest cent.) What happens to unit cost as the number of units produced increases?
Professional labor cost budget for a service company Based on the data in Exercise 7 and assuming that the average compensation per hour for staff is 40 and for partners is 175, prepare a professional labor cost budget for each department forLundquist Fretwell, CPAs, for the year ending May 31, 20Y8. Use the following column headings:
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Speedy Petes above. Assume that this information was used to construct the following formula for monthly delivery cost. TotalDeliveryCost=41,850+(12.00NumberofDeliveries) Required: Assume that 3,000 deliveries are budgeted for the following month of January. Use the total delivery cost formula for the following calculations: 1. Calculate total variable delivery cost for January. 2. Calculate total delivery cost for January.
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Prepare a cost of goods sold budget for the Crest Hills Manufacturing Co. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 854,000; beginning inventory of direct materials, 31,000; and ending inventory of direct materials, 26,000. Totals from other budgets included:
Budget performance reports for cost centers Partially completed budget performance reports for Runquist Company, a manufacturer of air conditioners, are provided below. a.Complete the budget performance reports by determining the correct amounts for the lettered spaces. b.Compose a memo to Jeff Kitchens, president of Meridian Company, explaining the performance of the Production Division for June.