The following information about the electricity cost of yourhouse for the first six months:Month kilowatt Hours Cost of electricity1234556005000700062005500680097085912009909601160By using excel: Find the cost equation for electricity costand estimate it for July if expected maintenance hours is5500 hours. Why is there difference between your numberand what included in May.

The expected cost of the electricity is the cost which might be incurred upon the business or any…

Answered: By using excel: Find the cost equation…

By using excel: Find the cost equation for electricity cost and estimate it for July if expected maintenance hours is 5500 hours. Why is there difference between your number and what included in May.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 1CE: The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include:...

See similar textbooks

Related questions

Q: Indicate if the CPA offers any type of assurance when performing the following a. An Interim…

A: The accountant has to perform the review in accordance with the standards as set by PCAOB.It is a…

Q: AA Company had the following items in its "Cash and cash equivalents account as of December 31,…

A: One of the items on the balance sheet that shows the worth of the company's assets that are cash or…

Q: 3. In August direct labor was 60% of conversion cost. If the manufacturing overhead for the month…

A: A company may incur a variety of costs over the course of production. They include both private and…

Q: The following information is available for Ivanhoe Company for the year ended December 31, 2022.…

A: Statement of cash flows is the statement which shows the increase or decrease in cash or cash…

Q: O hours @ $7.25) curred verhead rate per machine hour $5,650 $825 42 $28

A: Answer : Total cost that would appear on the job cost sheet for Job 252 = Direct material + Direct…

Q: Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance…

A: The cash flow statement is prepared to record the cash flow from various activities during the…

Q: A. Since the projects are mutually exclusive, which project would you recommend? Justify your…

A: Mutually Exclusive projects are those projects, which cannot be accepted simultaneously. Selection…

Q: Marin Inc. purchased computer equipment on March1,2020, for $68000. The computer equipment has a…

A: When a capital asset or property is purchased, the whole amount cannot be deducted as a business…

Q: Riley and Gretchen run a shuttle service from Times Square to New York's JFK airport. Last month,…

A: Net income after taxes = (Revenue - Expenses)×(1-tax rate)

Q: to compute the return on investment, and show (a) the profit margin, (b) the investment turnover,…

A: Answer : Operating income = $58,328 Invested assets = $317,000 Sales = $729,100 a) Profit margin…

Q: weedle-Dee and Tweedle-Dum form Alice Corporation with the transfer of the following. Tweedle-Dee…

A: ANSWER : Marie has income of $100,000 and $100,000 basis in her 400 shares of stock. Ethan have the…

Q: Paper Manufacturing makes and sells a single product called a Yute. The company is in the process of…

A: Selling and administrative expense are those which are incurred by the entity on its sales and…

Q: The following information relates to Oil Change Company. Oil Change Co. Projected Net Income For a…

A: ANSWER Here the projected net income for a week is given . Hence we need to Calculate projected net…

Q: The Elberta Fruit Farm of Ontario has always hired transient workers to pick its annual cherry crop.…

A: Whenever an investment is made, many prospects are taken into consideration whether the total…

Q: Sisters Berhad collects its accounts receivable in 48 The firm has a net profit margin of 8.6%. On…

A: Cash conversion cycle: It is the amount of time taken by an entity to convert it's amount vested in…

Q: ABC Inc. produces three products. Data concerning the selling prices and unit costs of the three…

A: Contribution margin takes into consideration only variable expenses. The variable expenses are…

Q: Cash outflows generated by capital investments include all of the following except: a) Initial…

A: Capital investment is a cash outflow for the business that comes along with other cash outflows…

Q: The XYZ Division of ABC Corp. generated a residual income of $400,000 and a return on investment of…

A: RETURN ON INVESTMENT Return on Investment is help to calculate the benefit an investor will…

Q: A CPA audits the financial statements of an issuer. Which statement relating to CAMs is TRUE? a. If…

A: Critical Audit Matters which is also written as CAMs are the matters which arises from the audit and…

Q: "Bates, how are you handling gossip in your department? I'm sure that you and your team are hearing…

A: In essence, "gossip" is gossiping about other people and their personal lives. Okay, I admit that…

Q: The standard unqualified opinion based on the audit of a public company's financial statements…

A: Audit report is the report which is issued by the auditor at the conclusion of the audit which…

Q: The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always…

A: Net Present Value (NPV) is the value of all future cash flows (positive and negative) over the…

Q: TAXES for the year ended December 31, 2011: Gross Sales, $223,000; Sales Returns and Allowances,…

A: Answer : Income statement : Revenue $223,000 Less : sales return $11,200…

Q: terminology matching asset turnover ratio, current ratio

A: Financial ratios are ratios which helps in understanding the data or the financial statements of the…

Q: A company issues a bond with a par value of $500,000 and a contract rate of 5%. Explain the concept…

A: Market rate is the current rate of interest at which similar bonds are trading in the market.…

Q: Flapjack Corporation had 7,817 actual direct labor hours at an actual rate of $12.20 per hour.…

A: Direct labour rate variance = (Standard rate-actual rate)actual hours

Q: et income on the income statement does not e in stockholders' equity from one period to a e in…

A: The statement of cashflow shows the inflow and outflow of cash transactions.

Q: d costs costs ct labor time variance is 7,100 6,200

A: Answer : Direct labor time variance = (Actual hour* Standard rate) - (Standard hour* Standard rate)…

Q: Comparative financial statements for Weller Corporation, a merchandising company, for the year…

A: The liquidity ratios are calculated to learn about the efficiency of the business to pay off its…

Q: Listed below are year-end account balances ($ in millions) taken from the records of Symphony…

A: Lets understand the basics. Statement of financial position is divided into three major sections…

Q: using gain disposal o pense of $750, an increase in Accounts Receivable of $2,400, and a decrease in…

A: The cash flow from various activities are recorded in the cash flow statement. The net cash flow is…

Q: Suppose you are the human resource manager for a cellular phone company with 700 employees. Top…

A: Various forms of non-wage remuneration that are given to workers in addition to their regular…

Q: Tinsel is considering making a $7,000 investment in a venture that its promoter promises will…

A: Answer:- Tax liability meaning:- The amount that a person, company or other entity owes to a…

Q: overhead erhead S: 234,900 251,700 92,100 $752,000 ng expenses $131,700 expenses 45,600 177,300 ain…

A: Answer : Total production cost per unit : Direct material $173,300 Direct labor 234,900…

Q: 2. Assume that the underapplied or overapplied overhead is closed to Cost of Goods Sold. Prepare the…

A: The overhead is said to be underapplied when applied overhead cost is lower than the actual…

Q: The following data is available for the Glitter Services Department of Butterfly Fairy Co. Sales…

A: Introduction: Departmental contribution to overhead is calculated by deducting cost of goods sold…

Q: Danville Co. provided the following information for the year ended December 31, 20Y1:…

A: Cost of goods manufactured means the amount of cost incurred on the making of the goods. It includes…

Q: ork's outstanding stock consists of 80,000 shares of noncumulative 7.5% preferred stock with a $5 ar…

A: Solution:- Determination of the amount of dividend to each year to each of two class of shareholders…

Q: Production costs (18,900 units): Direct materials Direct labor $171,300 235,500 247,300 93,300…

A: Using absorption Costing, all fixed and variable manufacturing costs are included in the product…

Q: A machine with a cost of $58,600 has an estimated residual value of $4,687 and an estimated life of…

A: The depreciation expense is charged on fixed assets as reduced value of the fixed asset with usage…

Q: Louisa is a lecturer at a public university and a single mother of three (3) children. All her…

A: A resident individual is subject to taxation on his/her income for a year and the tax liability is…

Q: Mighty Safe Fire Alarm is currently buying 58,000 motherboards from MotherBoard, Inc., at a price of…

A: Cost to make Cost to Buy Difference Direct materials (58,000 * $31) $1,798,000 Direct…

Q: Dr. Genius buys a house for $1,000,000 on a 30 year loan at 2.5% APR. Dr Ridiculous buys a…

A: Formula for calculating monthly Mortgage Payment = P [ i (1+i)n ] / (1+i)n-1 where, P = Principal…

Q: On January 1, Payson Incorporated had a retained earnings balance of $50,000. During the year,…

A: The retained earnings of the business are the Accumulated profits for past years. The retained…

Q: An internal auditor's work would most likely affect the nature, timing, and extent of an independent…

A: It is the responsibility of an Internal Auditor to verify that all of a company's operational…

Q: Replacement Value of Building $340,000 Face Value of Policy $300,000 Coinsurance Amount Clause (%)…

A: Answer : Replacement value of the building = $340,000 Coinsurance clause = 90% Insurance required =…

Q: In the books of Billings Computers Ltd., a journal entry is recorded to debit the bank loan account…

A: Lets understand the basics. Journal entry is required to make to record event and transaction in…

Q: Provincial Packages, Inc. operates a local parcel delivery service. The company keeps detailed…

A: Solution.. Total cost = Cost per kilometres * distance travelled At 122,000 km = $0.085 *…

Q: Assets Cash Accounts receivable Inventory Total current assets. Equipment Accumulated…

A: Cash Flow Statement :— It is one of the financial statement that shows change in cash and cash…

Q: A firm operated at 80% of capacity for the past year, during which fixed costs were $209,000,…

A: By the CVP method, operating income is obtained by subtracting fixed costs from the total…

Concept explainers

Manufacturing Costs

Manufacturing cost is the total cost of procuring or producing a product. In other words, the manufacturing cost is the cost that an individual or business owner undertakes for the manufacturing of goods.

Question

The following information about the electricity cost of your
house for the first six months:
Month kilowatt Hours Cost of electricity
1
2
3
4
5
5600
5000
7000
6200
5500
6800
970
859
1200
990
960
1160
By using excel: Find the cost equation for electricity cost
and estimate it for July if expected maintenance hours is
5500 hours. Why is there difference between your number
and what included in May.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Burnham Industries incurs these costs for the month: What is the prime cost?
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.
Assume a hotel rented 400, 480, and 420 rooms in the months of April, May, andJune, respectively; and the total housekeeping costs for the three months in question were $6,000, $6,800, and $6,200. With use of the high-low method, what is theamount of monthly fixed housekeeping costs?a. $1,000b. $1,500c. $2,000d. $2,500
A hotel having 100 rooms of which 80% are normally occupied in summer and 25% in winter. Period of summer and winter be taken as 6 months each and normal days in a month be assumed to be 30. Then, what is the value of total occupied room days?
Brisbane Indoor Sports, a sporting complex, has opening hours that fluctuate from month to month. The electricity costs and hours of operation for past six months is listed below:MonthTotal hours of operationTotal electricity costJanuary650$ 4,240February700$ 4,400March800$ 4,800April600$ 4,200May550$ 3,700June500$ 3,600Required:a) Use the high-low method to estimate the cost behaviour for the complex’s electricity costs, assuming that the variable costs vary in proportion to the hours of operation. Express the total cost behaviour in formula form (Y = a + bx). What is the variable electricity cost per hour of operation? (5 marks)b) During July, the complex will open for 570 hours. Predict the complex’s total electricity costs for July using the cost estimation method employed in above requirement a). (3marks)c) What is the main drawback of the high-low method of cost estimation? (2 marks, maximum 150 words)
Recent IT costs incurred each month at the head office of Dawn Ltd are detailed below. Apply the high/low method to establish how the cost behave and then select the correct prediction of cost for a month in which 770 client projects will be completed by the company month Number of clients project IT cost (£) 1 730 £116150 2 800 £123000 3 625 £112500 4 790 £120980 a. £94,200 b. £121,200 c. £122,000 d. £119,780
otal cost and number of units in the first seven months of 2020 are given below. According to this information, which of the following will be total cost in August if the company produces 600 units? Periods Total Cost No.of Units January 36,800 400 February 37,580 415 March 39,400 450 April 40,960 480 May 42,260 505 June 43,820 535 July 44,860 555 Select one: a. 48000 b. 53650 c. 51350 d. 47200
Pablo Company wishes to determine the fixed portion of its maintenance expenses (a semi-variable expense), as measured against direct labor hours for the first three months of the year. Information for the first quarter is as follows (refer to the attached picture): What is the fixed portion of Pablo Company’s maintenance expense using high-low method? * direct hours labor maintenance costs January 25000 210000 February 30000 240000 march 27000 222000
Nick Andrewson uses gas to heat his home. He has accumulated the following information regarding his monthly gas bill and monthly heating degree-days. The heating degree-days value for a month is found by first subtracting the average temperature for each day from 65 degrees and then summing these daily amounts together for the month. Month Heating Degree-Days Gas Bill February 850 $129 April 300 $ 52
The cost data for Evencoat Paint for the year 2019 is as follows: Evencoat Paint data Month Gallons of Paint Produced Equipment Maintenance Expenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Y=$ + x What are the fixed costs? What are the variable costs per gallon of paint produced? Predict the maintenance costs if 90,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced.
The following information is available for a company's utility cost for operating its machines over the last four months. Month Machine hours Utility cost January 900 $ 5,450 February 1,800 $ 6,900 March 2,400 $ 8,100 April 600 $ 3,600 Using the high-low method, the estimated variable cost per machine hour for utilities is:
Total cost and number of units in the first seven months of 2020 are given below. According to this information, which of the following is the cost equation? Periods Total Cost No.of Units January 45,750 500 February 46,305 510 March 46,860 520 April 48,248 545 May 49,358 565 June 50,190 580 July 51,855 610 choose one a. Y=18000+55.5*X b. Y=21000+50*X c. Y=19000+52.5*X d. Y=22500+48.3*X