Show the solution in excel form and on how you got it. 2.Suppose that you are the manager of a coffee shop, and you are planning to invest on anew coffee-maker machine designed to increase the productivity of your employees.A. Complete the table below.Total RevenueVariable CostDirect Fixed CostsIndirect Fixed CostsProfitCurrentSituationPhp1,000,000PETENCERELY400,000500,000100,000Projected Salesand ProfitPhp1,100,0000300,000590,000IB. Should the new coffee-maker machine be purchased? Justify your answer.100,000IncrementalRevenues andCosts110,000

Income Statement : It is the financial statement to prepared to know the performance and net income…

Suppose that you are the manager of a coffee shop, and you are planning to invest o new coffee-maker machine designed to increase the productivity of your employees. A. Complete the table below. Current Situation Projected Sales and Profit Incremental Revenues and

Suppose that you are the manager of a coffee shop, and you are planning to invest o new coffee-maker machine designed to increase the productivity of your employees. A. Complete the table below. Current Situation Projected Sales and Profit Incremental Revenues and

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter7: Variable Costing For Management analysis

Section: Chapter Questions

Problem 5DQ

See similar textbooks

Related questions

Q: Martinez Company’s relevant range of production is 7,500 units to 12,500 units. When it produces and…

A: The manufacturing costs of a company include direct material, direct labor, and manufacturing…

Q: Fujita, Incorporated, has no debt outstanding and a total market value of $369,600. Earnings before…

A: EPS (Earnings per share) which states how much amount of money business makes for every share as…

Q: Using the following performance data, calculate the volume adjusted labor rate variance and volume…

A: Variance is the measure which is used to determine the difference between the standard costs and the…

Q: Cherokee Manufacturing Company established the following standard price and cost data:…

A: Introduction: A flexible budget variation is any discrepancy between the outcomes provided by a…

Q: Cherokee Manufacturing Company established the following standard price and cost data:…

A: Introduction: A pro forma income report is a report that indicates a company's adjusted income after…

Q: An obligation of P31,300 is due on April 16, 2013. What is the value of this obligation on December…

A: Compound Interest is calculated on Beginning Outstanding Amount for the first time. Next interest is…

Q: According to our authors, explain the concept of “lower-of-cost-or-market.”

A: When a company prepares its financial statement, it reports certain items in the financial statement…

Q: What type of cost accounting system would be most appropriate to be used by a candy making company?…

A: Manufacturing Company: A manufacturer is a person or corporation that manufactures completed things…

Q: -ials rhead ad ed per year се 3.00 per unit $ 17.00 per unit $ 11.00 per unit $ 0.90 per unit $…

A: Absorption costing refers to the concept of determining the cost of a product manufactured by a…

Q: The table below provides the total revenues and costs for a dental practice for one year Total…

A: Explicit costs is a payments made to others during the course of running a business that represent…

Q: On January 4, Year 1, Ferguson Company purchased 168,000 shares of Silva Company directly from one…

A: Introduction: A journal entry is a record of a business deal in the accounting system of the…

Q: Starlight Drive-Ins Ltd. borrowed money by issuing $5,000,000 of 7% bonds payable at 95.5 on July 1,…

A: The bonds are the financial instruments for the business that are used to raise money from the…

Q: Instructions: Identify each of the following accounts as an asset, Liability or Equity. DESCRIPTION…

A: Introduction: Balance sheet: All the assets and liabilities are to be shown in Balance sheet. It…

Q: Suppose initially that the United States is consuming 2 boots and 12 shirts and Canada is consuming…

A: If US and Canada both specialize, then the US will produce only shirts and Canada will produce only…

Q: The following list of accounts is from the adjusted trial balance for Monty Corporation: Accounts…

A: The income statement is an essential part of the financial statements of the company. It is prepared…

Q: Your next-door neighbor recently began a new job as assistant controller for Conundrum Corporation.…

A: 1. Planned Production in units 4000 units 2. Actual Production In units 3400 units 3. Actual…

Q: 2. Change all of the numbers in the data area of your worksheet so that it looks like this: A…

A: Pre-determined overhead rate refers to the rate of allocation which is used for applying the…

Q: Question 4 a)For each of the following material after reporting period events of Andrew Ltd state…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Machinery Purchased for $ 800000 Accumulated depreciation value is $ 600000 Sold for $400000…

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

Q: The actors of the monetary policy process includes the central bank, commercial banks, depositors,…

A: Monetary Policy: Monetary policy refers to the process of controlling the amount of money that is…

Q: Fixed assets and current assets

Q: 1 2 5. Lacson invested P100,000 cash in the business 7. Paid P5,000 for office rent for the month…

A: Introduction: Journals: All the business transactions are to be recorded in Journals. Journals are…

Q: Compute years 1 and 2 double-declining-balance depreciation expense for Machine C, which has a cost…

A: Depreciation : It is the reduction in the value of assets due to its continuous use for production.…

Q: e. Time Interest earned Ratio E. Times Interest Earned Ratio Income before Interest and Taxes/…

A: Times Interest Earned Ratio=Income before Interest and TaxesInterest Expense

Q: A principal of P27,000 was placed in an investment which gives the interest of 12% compounded…

A: Future Value = Present Value x (1 + r)^n

Q: Bond (Held-to-Maturity)Investment Journalize the entries to record the following selected bond…

A: At the time of maturity of bonds at par, investment in bonds account is credited with the nominal/…

Q: Describe your understanding of budgets, both fixed and flexible, in the context of controlling and…

A: Organizations produce budgets for a variety of purposes, including cost control, performance…

Q: PA9-2 (Algo) Recording and Interpreting the Disposal of Long-Lived Assets [LO 9-5] Ly Company…

A: Depreciation is charged against the value of fixed assets. It can be calculated by using the…

Q: Neko Case decides to open a cleaning and laundry service near the local college campus that will…

A: You have posted a multiple part question, so as per our policy only the first three parts (i.e. 5,6…

Q: The 2020 income statement of Blossom Corporation showed net income of $1,271,000, which included a…

A: Net Income- Net income is the remaining amount after expenses and cost of goods sold have been…

Q: Hex Industries reports the following information for May: Sales Fixed cost of goods sold Variable…

A: Gross profit can be calculated by deducting the cost of goods sold from net sales. The cost of goods…

Q: Sunnyvale Computer Company sells a line of computers that carry a six-month warranty. Customers are…

A: Warranty is the promise made to the buyer of the product by the seller to repair or replace the…

Q: Transactions and events during 2021 (summarized in thousands of dollars) follow: a. Borrowed $12…

A: Ratio Analysis - The ratio is the technique used by the prospective investor or an individual or…

Q: 1 Lacson invested P100,000 cash in the business 2 3 4. 5. Paid P5,000 for office rent for the month…

A: Introduction: Journals: Another name for journals is book of prime entries. All the business…

Q: 1 The sum of P35,000 invested on April 16, 2009 amounts to P58,300 on July 16, 2013. At what rate…

A: Present Value Or Principal Amount :— It is the value of Amount today Or Amount invested in present…

Q: Which of the following costs would be included on an income statement for both a merchandising…

A: Merchandising concern - This entity deals with buying and selling inventory from the supplier to the…

Q: If the selling price per unit is $50, the variable expense per unit is $20, and total fixed expenses…

A: Introduction: Break even sales dollars: It tells the level of sales value where there is no profit…

Q: Required information PA9-1 (Algo) Computing Acquisition Cost and Recording Depreciation under Three…

A: In straight line method of depreciation the depreciation is being charged uniformly over the…

Q: how much did Juan have

A: Introduction: A specific kind of retirement savings account is a 401(k) plan. It is a tax-deferred…

Q: Calculate the material variances. Calculate the labor variances. Complete your calculations by…

A: A variance is a difference between actual measured output and a basis, such as a budgeted amount.…

Q: mpany’s financial statements as well as the Industry Average Ratios are provided as follows. Star…

A: Ratio Analysis : It is the numeric relationship between the two items of the financial statements to…

Q: Ernest Company uses an imprest petty cash system. The fund was established on March 1 with a balance…

A: Solution: Petty cash fund is established to provide business with sufficient to cash to meet minor…

Q: In recording the entry to record the purchase of raw materials on account in a job order cost…

A: Job order cost accounting is being followed by many manufacturing companies.It helps to record all…

Q: 9 15 Purchased supplies on account for $1,100 from Digital Shot Company. Received $3,500 cash…

A: Introduction: Journals: All the business transactions are to be recorded in Journals. Journals are…

Q: Martinez Company’s relevant range of production is 7,500 units to 12,500 units. When it produces and…

A: Variable costs :- are costs that change with each level of output while fixed costs do not change…

Q: Calculate the ratio (expressed to two decimal places) for 2021 to reflect each of the following:…

A: 1) An indicator of how profitable a company is relative to its total assets. Is return on asset…

Q: Portsmouth Company makes upholstered furniture. Its only variable cost is direct materials. The…

A: Contribution margin per unit=Sales price per unit-Variable cost per unit

Q: Belle Company reports the following information for the current year. All beginning inventory…

A: Introduction: Absorption costing is a method of calculating inventory costs. It includes variable…

Q: MAKE A BASIS AND DISCUSSION ON THE EFFICIENCY RATIO OF NESTLE (ASSET TURNOVER, INVENTORY TURNOVER,…

A: Efficiency ratios are the ratios that are calculated to check the efficiency of the organization or…

Q: Nature of Transaction 1. Cash payment on hydro bill that arrived today 2. Cash sale 3. Bank interest…

A: Introduction: Journals: All the business transactions are to be recorded in Journals. Journals also…

Question

Show the solution in excel form and on how you got it.

2.
Suppose that you are the manager of a coffee shop, and you are planning to invest on a
new coffee-maker machine designed to increase the productivity of your employees.
A. Complete the table below.
Total Revenue
Variable Cost
Direct Fixed Costs
Indirect Fixed Costs
Profit
Current
Situation
Php1,000,000
PETENCERELY
400,000
500,000
100,000
Projected Sales
and Profit
Php1,100,000
0
300,000
590,000
I
B. Should the new coffee-maker machine be purchased? Justify your answer.
100,000
Incremental
Revenues and
Costs
110,000

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 3

VIEW

Step by step

Solved in 3 steps

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

Jakarta Company is a service firm with current service revenue of $400,000 and a 40% contribution margin. Its fixed costs are $80,000. Maldives Company has current sales of $6,610,000 and a 45% contribution margin. Its fixed costs are $1,800,000. What is the margin of safety for jaka rta and Maldives? Compare the margin of safety in dollars between the two companies. Which is stronger? Compare the margin of safety in percentage between the two companies. Now, which one is stronger? Compute the degree of operating leverage for both companies. Which company will benefit most from a 15% increase in sales? Explain why. Illustrate your findings in an Income Statement that is increased by 15%.
a) Calculate the contribution margin per unit.b) Calculate the number of units Beauty Supplies Company must sell each year to break even.c) Calculate the number of units Beauty Supplies Company must sell to yield a profit of $160,000.d) Managers may use Sensitivity analysis in their accounting system.i) What is sensitivity analysis? ii) How is Sensitivity analysis useful to managers?
For a certain company, the cost function for producing x items is C(x)=40x+200, and the revenue function for selling x items in R(x)=−0.5(x−80)2+3,200. The maximum capacity of the company is 110 items. The profit function P(x) is the revenue function R(x) (how much it takes in) minus the cost function C(x) (how much it spends). In economic models, one typically assumes that a company wants to maximize its profit, or at least make a profit!Assuming that the company sells all that it produces, what is the profit function?P(x)= Preview Change entry mode . Hint: Profit = Revenue - Cost as we examined in Discussion 3. What is the domain of P(x)?Hint: Does calculating P(x) make sense when x=−10 or x=1,000? The company can choose to produce either 40 or 50 items. What is their profit for each case, and which level of production should they choose?Profit when producing 40 items = Number Profit when producing 50 items = Number Can you explain, from our model, why the company makes less profit…
Suppose a ceiling fan manufacturer has the total cost function C(x) = 35x + 1200 and the total revenue function R(x) = 65x. (a) What is the equation of the profit function P(x) for this commodity? P(x) = (b) What is the profit on 20 units? P(20) = Interpret your result. The total costs are less than the revenue. The total costs are more than the revenue. The total costs are exactly the same as the revenue. (c) How many fans must be sold to avoid losing money? fans
A company produces and sells a product. The company has found that the costto produce x units of the product is given by C(x) = 50x + 200 (in dollars),and the revenue from selling x units is given by R(x) = 100x - x? (in dollars).What is the number of units the company should produce and sell to maximize profit
Explain margin of safety and why it is an important measurement for managers. Jakarta Company is a service firm with current service revenue of $400,000 and a 40% contribution margin. Its fixed costs are $80,000. Maldives Company has current sales of $6,610,000 and a 45% contribution margin. Its fixed costs are $1,800,000. A. What is the margin of safety for Jakarta and Maldives? B. Compare the margin of safety in dollars between the two companies. Which is stronger? C. Compare the margin of safety in percentage between the two companies. Now, which one is stronger?
Classify the following type of cost with necessary reasons:1.A company had paid 15,50,000 to a marketing research company to find expected demand of the newly developed product of the company2.A company has invested 50,00,000 in a project. The company could have earned 6,00,000 by investing the amount in proper government securities.3.Accountant of a cloth factory paid 88,000 for water which has been used for washing the clothes.
Gwen is the managerial accountant in charge of Company A, which sellswater bottles. She previously determined that the fixed costs of Company A consist ofproperty taxes, a lease, and executive salaries, which add up to P500,000. Thevariable cost associated with producing one water bottle is P80 per unit. The waterbottle is sold at a premium price of P500. a. Formulate the total cost function.b. Formulate the revenue function.c. Formulate the profit function.d. Determine the breakeven quantity and the breakeven sales.e. Use the graphical method to determine the breakeven point.
A manufacturing firm is choosing between two models of equipment that would lessen labor costs. Machine A has a purchase price of $36,500 and $36,300 for Machine B. You have additional data for repair costs per machine:How much is the savings amount for your chosen alternative if the firm is earning 7% return on its capital
A small company manufactures a certain item and sells it online. The company has a business model where the cost, C in dollars, to make x items is given by the equation C = 20/3 x + 50. The revenue R , in dollars , made by selling x items is given by the equation R = 10x. How many items must the company sell in order for the cost to equal their revenue?
How I can resolve this problem. The management of a firm wants to introduce a new product. the product will sell for $4 a unit and can be produced by either of two scales of operation. in the first, total cost are. TC= $3,000 +$2.8Q In the second scale of operation, total cost are TC=$5,000+$2.04Q a. what is the break-even level of outpur for each scale of operation? b. what will be the firm;s profit for each scale of operation if sales reach 5,000 units? c. one-half of the fixed cost are noncash(depreciation) . all other expenses are for cash. if sale are 2,000 units, will cash receipts cover cash expenses for each scale of operation? d. the anticipaded levels of sales are the following: Year Unit Sales 1 4,000 2 5000 3 6,000 4 7,000 If management selects the scale of production which higher fixed cost, what can it expect…
1.Use the table below to answer the following questions. Resource Prices A B C Labor $5 5 4 3 Capital 10 2 3 5 Entrepreneur 20 1 1 1 Assume that a firm finds its profits will be maximized when it produces 50 units of product W (i.e., “widgets”). Three techniques shown in the table above will produce exactly 50 widgets. Which technique is the least expensive way of producing a widget? Suppose the firm chooses the least-cost method of production. If widgets sell for $2 each, what is the total economic profit of the firm?