The following spreadsheet shows a profit centre's variances against budget for a period. Some figures have...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following spreadsheet shows a profit centre's variances against budget for a period. Some figures have been omitted (omitted figures are labeled ???). A B C D E 1 Fixed budget Flexed budget Actual Variance Sale/Production units 1,200 1,500 1,500 300 2$ $ 4 Sale revenue 60,000 75,000 74,000 -1,000 5 Direct material 21,600 ??? 24,000 ??? 14,400 24,000 6 Direct labour 18,000 22,000 -4,000 7 Contribution ??? 28,000 ??? 8. Fixed costs 17,000 17,000 16,500 500 9. Profit 7,000 13,000 11,500 na What figure should appear in cell E5? A -2,400 B 2,400 С-3,000 D 3,000 23 The following spreadsheet shows a profit centre's variances against budget for a period. Some figures have been omitted (omitted figures are labeled ???). A B C D E 1 Fixed budget Flexed budget Actual Variance Sale/Production units 1,200 1,500 1,500 300 2$ $ 4 Sale revenue 60,000 75,000 74,000 -1,000 5 Direct material 21,600 ??? 24,000 ??? 14,400 24,000 6 Direct labour 18,000 22,000 -4,000 7 Contribution ??? 28,000 ??? 8. Fixed costs 17,000 17,000 16,500 500 9. Profit 7,000 13,000 11,500 na What figure should appear in cell E5? A -2,400 B 2,400 С-3,000 D 3,000 23
Expert Answer:
Answer rating: 100% (QA)
Variance Flexible Actual 27000 24000 3000 The correct option is D ... View the full answer
Related Book For
Personal Finance An Integrated Planning Approach
ISBN: 978-0136063032
8th edition
Authors: Ralph R Frasca
Posted Date:
Students also viewed these accounting questions
-
Figure (a) shows charged particles 1 and 2 that are fixed in place on an x axis. Particle t has a charge with a magnitude of |q1| = 8.00e. Particle 3 of charge q3 = + 8.00e is initially on the x axis...
-
Figure a shows an element of length d s = 1.00m in a very long straight wire carrying current. The current in that element sets up a differential magnetic field dB at points in the surrounding space....
-
What variances can be computed for direct material and direct labor when some materials or labor inputs are substitutes for others? What information does each of these variances provide?
-
Give the three ways to eliminate the balance in the overhead account at the end of the year.
-
A telephone interviewer asks, I would like to ask you about race. Are you Native American, Hispanic, African-American, Asian, or white?After the respondent replies, the interviewer says, We have...
-
Research the 1987 stock market crash and its effect on the economy?
-
Identify three business rules for an ATM system.
-
You are one of three carpenters assigned to complete a short construction project. Right before the start of the project, one of your fellow carpenters was hospitalized and will not be available to...
-
The following data were provided by Mystery Incorporated for the year ended December 31: Cost of Goods Sold Income Tax Expense Merchandise Sales (gross revenue) for Cash Merchandise Sales (gross...
-
Refer to the Bulletin of Marine Science (Apr. 2010) study of teams of fishermen fishing for the red spiny lobster in Baja California Sur, Mexico, Exercise 11.63 (p. 614). Recall that simple linear...
-
Briefly explain why the maximum number you can represent with a given number of binary bits differs from the "maximum count." Use an example to support your explanation.
-
You deposit $1000 in an account that pays 8% interest compounded semiannually. After 4 years, the interest rate is increased to 8.40% compounded quarterly. What will be the value of the account after...
-
A couple, Randall and Beth (both age 30) have come to see you regarding their financial situation. Randall works for a consulting firm earning $180,000 per annum. Beth is currently a stay home mother...
-
a. Discuss 3 factors that could cause Jamaica to experience economic growth. b. Describe how this would impact the country's production possibility curve. Criteria for Success a. Use APA guidelines...
-
Summative Assessment: Economic and Market Impact Report By this point in the course, you have developed an understanding of the relationship between economics and the costs of health care....
-
You belong to a start-up company that is designing and delivering a constellation of nanosatellites (that is, a system of very small satellites for Earth observation). For each satellite unit, the...
-
Does McDonalds use CRM technology to assist with building a relationship? How do they're use technology? What CRM tool do they use? What is the role of salesperson in selling your product to the end...
-
For the following exercises, write the polynomial function that models the given situation. Consider the same rectangle of the preceding problem. Squares of 2x by 2x units are cut out of each corner....
-
Suppose you can earn 10 percent on an investment rather than 8 percent. After 20 years, the future value will be 25 percent greater. True or false? Explain.
-
What is the distinguishing characteristic of term insurance? Why isnt deposit term true term insurance?
-
1. Explain some disadvantages of Cliffs current investment approach. 2. Construct a portfolio for Cliff, limiting your selections to mutual funds (assume that he sells his current stock and bond...
-
At 3:00 a.m. on November 22, 2010, 16-year-old Sydney McLemore was driving a Mazda3 with her friend, Natalie Hurst, in the front passenger seat. The vehicle was traveling south on Ross Bridge Highway...
-
On February 16, 2005, Joseph and Margaret Buset borrowed $192,000 from Fremont Investment & Loan (the Originator). The loan was secured by a mortgage on a residential condominium. The mortgage named...
-
Thomas Rusnack and his then-wife, Analisa Rusnack, opened a home equity line of credit (HELOC) with Cardinal Bank in August 2003. Between 2003 and 2006, the Rusnacks periodically drew on the HELOC...
Study smarter with the SolutionInn App