Problem 9: Consider the following information of X Ltd.MonthTotal CostsUnits (Meals)JanuaryFebruaryMarch$6,7207,2607,27011,06012,5808,6608,5809,55013,05011,0607,3207,3706,7907,4806,9901,2801,8101,6202,830AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchApril3,6302,6102,4602,6403,6202,8401,8201,6501,2601,8501,7102,94011,400Develop cost function according toi.High Low methodLeast Square Regression methodii.

These are methods used for obtaining the total cost incurred by the company.

Consider the following information of X Ltd. Total Costs Units (Meals) 1,280 1,810 1,620 2,830 Month January February March April May June July August September October November December January February March April $6,720 7,260 7,270 11,060 12,580 8,660 8,580 9,550 13,050 11,060 7,320 7,370 6,790 7,480 6,990 11,400 3,630 2,610 2,460 2,640 3,620 2,840 1,820 1,650 1,260 1,850 1,710 2,940

Consider the following information of X Ltd. Total Costs Units (Meals) 1,280 1,810 1,620 2,830 Month January February March April May June July August September October November December January February March April $6,720 7,260 7,270 11,060 12,580 8,660 8,580 9,550 13,050 11,060 7,320 7,370 6,790 7,480 6,990 11,400 3,630 2,610 2,460 2,640 3,620 2,840 1,820 1,650 1,260 1,850 1,710 2,940

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

MN.45.
Compute the sales and food costs for the volumes below from the following data: Menu Price $12.00 Food Cost 3.60 Covers Sales Food Cost 1 10 50
h9
1. Fruit Tea's data show the following information: Aug. 25,000 31 1.75 Estimated sales (units) Sales price per unit Direct labor per unit unit $ $ Labor rate per hour $ C. Direct materials budget d. Direct labor budget Sept. 25,000 31 $ $ $ 21 $ Nov. Dec. 27,500 28,000 $ $ 31 $ 31 1.75 $ 1.75 $ 1.50 $ 1.50 $ 1.50 1.50 $ 21 $ 24 $ 24 $ 24 Oct. 27,000 31 New machinery will be added in October. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next month's requirements. Direct material requires 2.5 pounds per unit at a cost of $5 per pound. The ending inventory required for direct materials is 20% of the next month's needs. In August, the beginning inventory is 3,750 units of finished goods and 13,125 pounds of materials. For the first quarter ending in October prepare a: a. Sales budget b. Production budget 4
Tenta Inks Company has compiled the following data for the last five months of operations: Month Labor Hours Cost of Sales August 160 ₱ 617 September 130 ₱553 October 180 ₱596 November 190 ₱725 December 110 532 Applying the HIGH-LOW METHOD, derive the cost equation. _____________________.
need answer of this Question Please Provide it
Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order Processing Costs 1 3,000 $49,620 2 1,500 30,225 4,400 72,420 2.800 49,140 2.300 41,865 25,860 37,500 3 4 S 6 7 1,200 2,000 NOTE: Round variable cost per unit answers to two decimal places, if appropriate. (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. $ 15:400 +5 24.26 * 8400 + M.SS* Correct (b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly production costs. If needed, an Excel worksheet is provided in the following link in order to create the scatter diagram: Scatter Diagram $ 15,622 X+$ 23.93 XX
Ht.9.
Computing Average Unit Costs The total monthly operating costs of Chili To Go are:$12,000 + $0.50X where X = servings of chili Determine the average cost per serving at each of the following monthly volumes: 100; 1,000; 5,000; and 10,000. Round answers to one decimal place. Volume Average Unit Cost 100 1,000 5,000 10,000 Determine the monthly volume at which the average cost per serving is $0.70.
8 ok Royal Enterprises has collected the following cost data for various levels of activity: Month June July August Required: a. Using the high-low method, calculate the variable cost per unit and the total fixed cost per month. Note: Round variable cost to 2 decimal places. b. What would the total cost be for a month with 5,350 units duced? Note: Do not round your intermediate calculations. a. Fixed Cost a. Variable Cost b. Total Costs Units Total Cost per Unit 3,450 5,850 7,050 $ 12.10 8.10 7.30 per month per unit
A7
10:20 (Feb 21-27) Food Cost 044 Beverage Cost Labor Cost Other Costs Total Costs Food Sales Beverage Sales Total Sales (Revenue) Total Profit • N Projected $6,971 $3,954 $8,423 $7,645 $26,993 $18,565 $12,872 $31,437 $4,444 56% السم Based on the actual results, what adjustments need to be made to Food and Beverage sales projections for next week? O b. Projections for next week should be increased to make up the difference from this week Actual $7,842 $4, 156 $9,541 $7,645 $29, 184 $14,326 $10,852 $25,178 -$4,006 O a. Projections for next week should be set the same as this week, so we can strive to reach our goals. O d. Projections for next week should be increased because we exceeded our projections this week ||| O O c. Because this week's actual profit (-$4006) came in below our projected profit ($4444), we should reduce next week's Food and Beverage sales projections.