08-18 at 11.37.45 AM_LI.jpg& Edit & CreateQUESTION 2Steve Richardson, management accountant at Jupiter Ltd, is examining the behaviour of quarterly maintenance costs for budgeting purposes. Steve collects the following data onmachine-hours worked and maintenance costs for the past eight quarters:Save AnswerQuarterMachine-hoursMaintenance costs1,200$2,15012.7501,5003.1,1002,000141,5002,700159001,4501,4902,800162,25071,3001,9501,000Required:Close Windowa. Estimate the cost function for the quarterly data using the high-low method,Save All AnswersClick Save and Submit to save and submit. Click Save All Answers to save all answers.DELL11:46 AM30°C AQI 23 A A 90)8/18/2021pe here to search hatsApp Image 2021-08-18 at 11.38.00 AM.jpeg7501,5001,1002,000141,5002,7009001,450161,4902,800171,3002,2501,0001,950Required:a. Estimate the cost function for the quarterly data using the high-low method. *b. Steve anticipates that Jupiter Ltd will operate machines for 1,300 hours in quarter 9, Calculate the predicted maintenance costs in quarter 9 using the cost functionestimated in requirement (a).*Please indicate which question you are answering for each.For the toolhar press AL T+F10 (POor ALT+EN+F10.(Mac)Save All AnswersClose WindowClick Save and Submit to save and submit. Click Save All Answers to save all answers.DELL11:46 AM30°C AQI 23O G G 4)8/18/2021O Type here to search

The high low level method is used to separate the fixed and variable cost from mixed cost.

QUESTION 2 Steve Richardson, management accountant at Jupiter Ltd, is examining the behaviour of quarterly maintenance costs for budgeting purposes. Steve collects the following data on machine-hours worked and maintenance costs for the past eight quarters: Save Answer Quarter Machine-hours Maintenance costs 1. 1,200 $2,150 12 750 1,500 3 1,100 2,000 14 1,500 2,700 900 1,450 15 1,490 2,800 16 2,250 17 1,300 1,000 1,950 18 Required: for she quarterly data using the high-loyw method,

QUESTION 2 Steve Richardson, management accountant at Jupiter Ltd, is examining the behaviour of quarterly maintenance costs for budgeting purposes. Steve collects the following data on machine-hours worked and maintenance costs for the past eight quarters: Save Answer Quarter Machine-hours Maintenance costs 1. 1,200 $2,150 12 750 1,500 3 1,100 2,000 14 1,500 2,700 900 1,450 15 1,490 2,800 16 2,250 17 1,300 1,000 1,950 18 Required: for she quarterly data using the high-loyw method,

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter13: Budgeting And Standard Costs

Section: Chapter Questions

Problem 13.2.6P: Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with...

See similar textbooks

Similar questions

Budgeted income statement and supporting budgets The budget director of Jupiter Helmets Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for May: Prepare a cost of goods sold budget for May. Work in process at the beginning of May is estimated to be $4200. and work in process at the end of May is desired to be $3800.
Using the information for Crable and Tesch, the systems consultants in P9-3 and P9-4, prepare a budgeted income statement for the year ended December 31, 2016.
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.
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:
Give typing answer with explanation and conclusion The manufacturing overhead budget at Polich Corporation is based on budgeted direct labor-hours. The direct labor budget indicates that 8,000 direct labor-hours will be required in February. The variable overhead rate is $9.60 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $114,400 per month, which includes depreciation of $18,180. All other fixed manufacturing overhead costs represent current cash flows. The company recomputes its predetermined overhead rate every month. The predetermined overhead rate for February should be:
A manufacturing company's budgeted income statement includes the following data: Data extracted from budgeted income statement Mar Apr May Jun Sales revenue $130,000 $80,000 $130,000 $120,000 Commission expense (15% of sales) 19,500 12,000 19,500 18,000 Salaries expense 33,000 33,000 33,000 33,000 Miscellaneous expense—5% of sales 6500 4000 6500 6000 Rent expense 3600 3600 3600 3600 Utilities expense 2300 2300 2300 2300 Insurance expense 2600 2600 2600 2600 Depreciation expense 4200 4200 4200 4200 The budget assumes that 60% of commission expenses are paid in the month they are incurred and the remaining 40% are paid one month later. In addition, 50% of salaries expenses are paid in the same month, and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense, and utilities expenses are assumed to be paid in the same month in which they are incurred. Insurance has been paid in advance for the year on January 1.Calculate total budgeted cash…
High-low method. Wayne Mueller, financial analyst at CELL Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hours worked and utility costs for the past 8 quarters:
Given below the 2PM’s Hairstyling information for the month ended June 30: a) Revenue and cost formula Budgeted client-visits q Revenue RM180q Wages and salaries RM65,000 + RM37q Hairstyling supplies RM1.50q Client gratuities RM4.10q Electricity RM1500 + RM0.10q Rent RM28,500 Liability insurance RM2,800 Employee health insurance RM21,300 Miscellaneous RM1,200 + RM0.20q b) The budgeted client-visits were 1,000. c) Income statement for the month ended June 30: 2PM’s Hairstyling Income Statement For the month ended June 30 Actual client-visits 1100 RM Revenue 194,200 Expenses: Wages and salaries 106,900 Hairstyling supplies 1,620 Client gratuities 6,870 Electricity 1,550 Rent 28,500 Employee health insurance 22,600…
Relevant data from Picta Company’s operating budgets are presented below. The company’s financial year ends on 30 June. Quarter 1Quarter 2Sales$248,470$251,539Direct material purchases120,295128,832Direct labor76,55374,289Manufacturing overhead26,00024,400Selling and administration expenses33,50033,500Depreciation included in selling and administration expenses 2,000 2,500 Collection from customers230,524220,116Cash payments for purchases114,345118,346 Additional data:Equipment was sold in July for $8,000 and $4,500 in November. Dividends of $5,500 were paid in August. The beginning cash balance was $80,395 and a required minimum cash balance per quarter is $60,000. The company has a 15% open line of credit for $70 000 with their bank. Required: a) Use this information to prepare a cash budget for the first two quarters of the year. bi) Briefly comment on Picta Company’s expected cashflow position in the first two quarters of the year.
A manufacturing company's budgeted income statement includes the following data: Data extracted from budgeted income statement Mar Apr May Jun Sales revenue $120,000 $90,000 $130,000 $110,000 Commission expense (10% of sale) 12,000 9000 13,000 11,000 Salaries expense 33,000 33,000 33,000 33,000 Miscellaneous expense—5% of sales 6000 4500 6500 5500 Rent expense 3700 3700 3700 3700 Utilities expense 2000 2000 2000 2000 Insurance expense 2900 2900 2900 2900 Depreciation expense 4500 4500 4500 4500 The budget assumes that 60% of commission expenses are paid in the month they were incurred, and the remaining 40% are paid one month later. In addition, 50% of salaries expenses are paid in the month incurred and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense, and utilities expenses are assumed to be paid in the same month in which they are incurred. Insurance was prepaid for the year on January 1. How much is the total of the budgeted…
Budget Performance Report for a Cost CenterThe Eastern District of Adelson Inc. is organized as a cost center. The budget for the Eastern District of Adelson Inc. for themonth ended December 31 is as follows:Sales salaries $819,840System administration salaries 448,152Customer service salaries 152,600Billing salaries 98,760Maintenance 271,104Depreciation of plant and equipment 92,232Insurance and property taxes 41,280Total $1,923,968During December, the costs incurred in the Eastern District were as follows:Sales salaries $818,880System administration salaries 447,720Customer service salaries 183,120Billing salaries 98,100Maintenance 273,000Depreciation of plant and equipment 92,232Insurance and property taxes 41,400Total $1,954,452Required:1. Prepare a budget performance report for the manager of the Eastern District of Adelson for the month of December.Enter all amounts as positive numbers. If an amount box does not require an entry, leave it blank, or enter zero "0".
Jackson Inc. listed the following data for 2019: Budgeted factory overhead $1,352,000 Budgeted direct labor hours 80,000 Budgeted machine hours 41,600 Actual factory overhead 1,100,000 Actual direct labor hours 87,700 Actual machine hours 40,800 If overhead is applied based on direct labor hours, overapplied/underapplied overhead is (round calculations to 2 significant digits): Multiple Choice $382,130 overapplied. $382,130 underapplied. $331,166 underapplied. $331,166 overapplied. $ − 0 −. My answer is $226,000 overapplied. But I don't show that answer.