Q3: The accountant of Manama Corporation has collected the following data on its copy machine costs for the last six months of the year. Month Number of copies Total copy cost $14,000 July 3,500 August September 3,200 13,500 4,100 16,000 October 5,100 18,000 November 5,600 18,500 December 4,800 17,500 Requirements : 1- Use the regression analysis method to: a- Estimate the cost function (Y= F+vX). b- What percentage of the copy cost depends on number of copies? What portion of the fluctuation is not explained by that cost driver? You need to perform this using Excel. Submit the excel sheet along with your paper. 2- Using the high-low method, calculate the total fixed factory overhead cost and the variable factory overhead cost per direct labour hour and Prepare the cost function. 3. What would the total factory copy cost be at a level of 4,600 copies using each method above? 4. Which prediction method is the best method? Why?

Q3: The accountant of Manama Corporation has collected the following data on its copy machine costs for the last six months of the year. Month Number of copies Total copy cost $14,000 July 3,500 August September 3,200 13,500 4,100 16,000 October 5,100 18,000 November 5,600 18,500 December 4,800 17,500 Requirements : 1- Use the regression analysis method to: a- Estimate the cost function (Y= F+vX). b- What percentage of the copy cost depends on number of copies? What portion of the fluctuation is not explained by that cost driver? You need to perform this using Excel. Submit the excel sheet along with your paper. 2- Using the high-low method, calculate the total fixed factory overhead cost and the variable factory overhead cost per direct labour hour and Prepare the cost function. 3. What would the total factory copy cost be at a level of 4,600 copies using each method above? 4. Which prediction method is the best method? Why?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter2: Basic Cost Management Concepts

Section: Chapter Questions

Problem 22E: Ellerson Company provided the following information for the last calendar year: During the year,...

See similar textbooks

Similar questions

Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.
Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.
Standards for nonmanufacturing expenses The Radiology Department provides imaging services for Northeast Washington Medical Center. One important activity in the Radiology Department is transcribing digitally recorded analyses of images into a written report. The manager of the Radiology Department determined that the average transcriptionist could type 800 lines of a report in an hour. The plan for the first week in July called for 64,000 typed lines to be written. The Radiology Department has two transcriptionists. Each transcriptionist is hired from an employment firm (hat requires temporary employees to be hired for a minimum of a 40-hour week. Transcriptionists are paid $18.00 per hour. The manager offered a bonus if the department could type more than 70,000 lines for the week, without overtime. Due to high service demands, the transcriptionists typed more lines in the first week of July than planned. The actual amount of lines typed in (he first week of July was 70,400 lines, without overtime. As a result, the bonus caused the average transcriptionist hourly rate to increase to $20.00 per hour during the first week in July. Instructions Are there any performance-related issues that the labor time and rate variances fail to consider? Explain.
4. Selected account balances for the year ended December 31 are provided below for MelodyCompany:Selling and Administrative salaries . . . . . . . . . . . . . . . . . . . . P110,000Purchases of raw materials . . . . . . . . . . . . . . . . . . . . . . . . . . P290,000Direct Labor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ?Advertising expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . P80,000Manufacturing overhead . . . . . . . . . . . . . . . . . . .. . . . . . . . . . P270,000Sales commissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . P50,000 Inventory balances at the beginning and end of the year were as follow:Beginning of the year End of the yearRaw materials . . . . . . . . . . . . . . P40,000 P10,000Work in process . .. . . . . . . .. . . ? P35,000Finished goods . . . . . . . . . . . . . P50,000 ? The total manufacturing costs for the were P683,000; the goods available for sale totaledP740,000; and the…
If the beginning balance for June of the materials inventory account of AAA Enterprise was P250,000, the materials purchased for the month is P1,200,000 and the ending balance for the month was P300.000, how much was the materials used for the month? 1. P 1,150,000 2. P 1.250,000 3. P 1,500,000 4. P 1,750,000 Group of answer choices 1 2 3 4
CASE 1 The following are the information obtained from AMC Company:July August SeptemberCash Sales P24,000 P32,000 P36,000Credit Sales 220,000 300,000 240,000Purchases 180,000 240,000 220,000Operating Expenses 30,000 36,000 32,000Interest Expense - 4,000 -Credit sales are collected 50% in the month of sale, 40% in the month following, 8% in the second monthfollowing, and 2% uncollectible. Credit sales for May and June are expected to be P200,000 and P180,000,respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in themonth following. Purchases for June are estimated at P160,000. Expenses include depreciation of P4,000monthly and are paid in the month incurred. The cash balance on June 30, 201A is P54,000.Required: Prepare a cash budget by month for the quarter ending September 30, 201A. Support your solutionwith schedules of cash receipts and cash payments CASE 2 Sanchez Company, a wholesaler, budgeted the following sales for the…
The following represents the financial information for Plaza Plastics for May and June: May June Sales revenue $ 747,000 $ 540,000 Costs Scrap $ 2,000 $ 1,710 Process inspection 2,880 1,760 Quality training 23,780 11,720 Product testing equipment 5,180 4,340 Field testing 8,420 6,320 Warranty repairs 3,380 3,080 Rework 19,780 16,670 Preventive maintenance 16,220 8,570 Legal expense for warranty claims 7,820 4,340 Materials inspection 11,300 11,180 Required: Classify these items into Prevention, Appraisal, Internal failure, or External failure costs. Calculate the ratio of the prevention, appraisal, internal failure, and external failure costs to sales for May and June
4. The purchases of Chicken Wings Inc. during the year are as follows: 1st quarter- P1,368,000 2nd quarter- P1,320,000 3rd quarter- P2,175,000 4th quarter- P840,000 The entity’s physical count revealed the following balances of cost and NRV, respectively: January 1- P20,000; P19,000 June 30- P40,000; P38,500 December 31- P35,000; P34,600 The gross profit ratio for the year is 35%. If the company uses the allowance method, how much is the loss on inventory write-down to be recognized in the 2nd quarter?
The following information is given to you from which you are required to prepare a Statement of Cost and Sales for the period ended on 30th June 2023:Consumable material: KOpening stock 20,000Purchases 122,000Closing stock 10,000Direct wages 36,000Direct Expenses 24,000Factory overheads 50 % of direct wagesOffice and administration overheads 20% of works costSelling and distribution expenses K3 per unit soldUnits of finished goods:In hand at the beginning of the period (Value K12,500) 500Units produced during the period 12,000In hand at the end of the period 1,500Profit on selling price 20% There is no work-in-progress either at the beginning or at the end of the period.
JOURNAL ENTRIES - ACTUAL COST SYSTEM The following transactions of Lakay Manufacturers were incurred during the month of May. a. Materials purchases on account, P750,000. b. Purchase returns and allowances, P50,000. c. Payment of payroll: Total Earnings P655,000 Less: SSS premiums P17,500 Philhealth premiums 8,000 Pag-IBIG premiums 2,500 Withholding taxes 12,000 Advances to employees 65,000 Union dues 30,000 135,000 Net amount P520,000 d. Breakdown of the payroll: factory, 60% (Direct labor - 50%, Superintendence - 40%; Indirect labor - 10%); sales, 25%; and, office, 15%. e. Disbursements are made for the following: Insurance premiums - factory building and contents P2,500 Lubricants, rags, brooms and insecticide 800 Electricity bill 4,100 Water bill 900 f. Sales on account, P2,200,000. g. Sales returns and allowances, P60,000. h. The following are paid: Bond paper, pencils and other office supplies P1,500 TV and radio advertisements 6,000 Plastic bags, masking tapes and…
The following information is from Teas Window’s financial records. The company buys its raw material on account and pays:• 60% of accounts payable during the month of purchase• 35% in the first month after purchase• 5% in the second month after purchaseMonth PurchasesApril 50,000May 52,000June 60,000July 72,000Compute the estimated total cash disbursements during July. Show your calculations
For February, sales revenue is P700,000; sales commissions are 5% of sales; the sales manager's salary is P96,000; advertising expenses are P80,000; shipping expenses total 2% of sales; and miscellaneous selling expenses are P2,100 plus 1/2 of 1% of sales. Total selling expenses for the month of February are: * A. P230,600 B. P185,650 C. P189,500 D. P196,100