GreenforGold is a new urban farm who aims to tap into the demand for local food...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
GreenforGold is a new urban farm who aims to tap into the demand for local food that became a community focus since the pandemic disruptions. They are proposing to grow strawberries, lettuce and tomatoes in vertical farming units that take a smaller footprint and are going to use artificial lighting and mixes of synthetic nutrients to produce their fruits and vegetables. They've been trying to project what their utility costs (for both water and electricity) will be for the upcoming year and have been able to gather data from another vertical urban farm in the area that focuses on peppers and eggplant. The info about the utilities is captured below Water Electricity Veggie (liters) use (kwH) (kg) Water Cost Electricity Cost January 6,445 8110 1000 $ 631.38 $ 1,389.50 February 7,065 8910 1100 $ 677.88 $ 1,563.60 March 9,235 11710 1450 $ 840.63 $ 2,011.60 April 17,620 22585 2800 $ 1,469.50 $ 3,751.60 May 11,283 11385 1400 $ 994.23 $ 1,959.60 June 12,025 15385 1900 $ 1,049.88 $ 2,599.60 July 20,835 26610 3300 $ 1,710.63 $ 4,395.60 August 21,455 27410 3400 $ 1,757.13 $ 4,523.60 September 23,625 30195 3750 $ 1,919.88 $ 4,969.20 October 24,183 30915 3840 $ 1,961.73 $ 5,084.40 November 15,701 19955 2480 $ 1,325.58 $ 3,330.80 December 10,679 13475 1670 $ 948.93 $ 2,294.00 Annual 180,151 226,645 28,090 $ 15,287.33 $ 37,873.10 December 10,679 13475 1670 $ 948.93 $ 2,294.00 Annual 180,151 226,645 28,090 $ 15,287.33 $ 37,873.10 Requirement 1 Using the High-Low method calculate the variable and fixed costs for water (present in a cost formula) 2 Using the High-Low method calculate the variable and fixed costs for electricity (present in a cost formula) 3 Prepare a scattergraph and least squares regression trendline for assessing the use of veggie production as a cost driver for water (be sure that water cost is the Y axis) a. Is the veggie production a good choice of cost driver? Why or why not? b. What are the fixed and variable costs for water? - be sure to present in a cost formula 6 marks 6 marks 5 marks 2 marks 2 marks 5 marks b. What are the fixed and variable costs for electricity? - be sure to present in a cost formula 2 marks 2 marks 4 Prepare a scattergraph and least squares regression trendline for assessing the use of veggie production as a cost driver for electricity (be sure that electricity cost is the Y axis) a. Is the veggie production a good choice of cost driver? Why or why not? 5 Why is there a difference in the cost formulas using high-low method and the cost formulas using least squares regression? 1 mark 6 The company thinks that they will sell all of their veggies at a profit of $3/kg next year, but their variable costs for water will be 2x last year's amount (there is a drought predicted and the costs will increase), and their electricity costs will be 1.5x the last year's variable rate. a) Will they be able to cover those cost increases (assuming there are no changes to any other inputs, selling and admin expenses)? 5 marks b. What are the fixed and variable costs for electricity? - be sure to present in a cost formula 2 marks 5 Why is there a difference in the cost formulas using high-low method and the cost formulas using least squares regression? 1 mark 6 The company thinks that they will sell all of their veggies at a profit of $3/kg next year, but their variable costs for water will be 2x last year's amount (there is a drought predicted and the costs will increase), and their electricity costs will be 1.5x the last year's variable rate. a) Will they be able to cover those cost increases (assuming there are no changes to any other inputs, selling and admin expenses)? 5 marks 2 marks b) What will their new profit per kg of veggie production end up being? And how much in total? Exojev10 Total 38 marks GreenforGold is a new urban farm who aims to tap into the demand for local food that became a community focus since the pandemic disruptions. They are proposing to grow strawberries, lettuce and tomatoes in vertical farming units that take a smaller footprint and are going to use artificial lighting and mixes of synthetic nutrients to produce their fruits and vegetables. They've been trying to project what their utility costs (for both water and electricity) will be for the upcoming year and have been able to gather data from another vertical urban farm in the area that focuses on peppers and eggplant. The info about the utilities is captured below Water Electricity Veggie (liters) use (kwH) (kg) Water Cost Electricity Cost January 6,445 8110 1000 $ 631.38 $ 1,389.50 February 7,065 8910 1100 $ 677.88 $ 1,563.60 March 9,235 11710 1450 $ 840.63 $ 2,011.60 April 17,620 22585 2800 $ 1,469.50 $ 3,751.60 May 11,283 11385 1400 $ 994.23 $ 1,959.60 June 12,025 15385 1900 $ 1,049.88 $ 2,599.60 July 20,835 26610 3300 $ 1,710.63 $ 4,395.60 August 21,455 27410 3400 $ 1,757.13 $ 4,523.60 September 23,625 30195 3750 $ 1,919.88 $ 4,969.20 October 24,183 30915 3840 $ 1,961.73 $ 5,084.40 November 15,701 19955 2480 $ 1,325.58 $ 3,330.80 December 10,679 13475 1670 $ 948.93 $ 2,294.00 Annual 180,151 226,645 28,090 $ 15,287.33 $ 37,873.10 December 10,679 13475 1670 $ 948.93 $ 2,294.00 Annual 180,151 226,645 28,090 $ 15,287.33 $ 37,873.10 Requirement 1 Using the High-Low method calculate the variable and fixed costs for water (present in a cost formula) 2 Using the High-Low method calculate the variable and fixed costs for electricity (present in a cost formula) 3 Prepare a scattergraph and least squares regression trendline for assessing the use of veggie production as a cost driver for water (be sure that water cost is the Y axis) a. Is the veggie production a good choice of cost driver? Why or why not? b. What are the fixed and variable costs for water? - be sure to present in a cost formula 6 marks 6 marks 5 marks 2 marks 2 marks 5 marks b. What are the fixed and variable costs for electricity? - be sure to present in a cost formula 2 marks 2 marks 4 Prepare a scattergraph and least squares regression trendline for assessing the use of veggie production as a cost driver for electricity (be sure that electricity cost is the Y axis) a. Is the veggie production a good choice of cost driver? Why or why not? 5 Why is there a difference in the cost formulas using high-low method and the cost formulas using least squares regression? 1 mark 6 The company thinks that they will sell all of their veggies at a profit of $3/kg next year, but their variable costs for water will be 2x last year's amount (there is a drought predicted and the costs will increase), and their electricity costs will be 1.5x the last year's variable rate. a) Will they be able to cover those cost increases (assuming there are no changes to any other inputs, selling and admin expenses)? 5 marks b. What are the fixed and variable costs for electricity? - be sure to present in a cost formula 2 marks 5 Why is there a difference in the cost formulas using high-low method and the cost formulas using least squares regression? 1 mark 6 The company thinks that they will sell all of their veggies at a profit of $3/kg next year, but their variable costs for water will be 2x last year's amount (there is a drought predicted and the costs will increase), and their electricity costs will be 1.5x the last year's variable rate. a) Will they be able to cover those cost increases (assuming there are no changes to any other inputs, selling and admin expenses)? 5 marks 2 marks b) What will their new profit per kg of veggie production end up being? And how much in total? Exojev10 Total 38 marks
Expert Answer:
Related Book For
Management
ISBN: 9780730329534
6th Asia Pacific Edition
Authors: Schermerhorn, John, Davidson, Paul, Factor, Aharon, Woods, Peter, Simon, Alan, McBarron, Ellen
Posted Date:
Students also viewed these accounting questions
-
Emergency Medicine plays a vital role in the health care continuum in the United States. Michael Porters' five forces model of industry analysis provides an insight into the economics of emergency...
-
Aflac, Inc. is a large insurance company founded as American Family Life Assurance Company in 1955 by brothers Paul, John, and Bill Amos in Georgia, United States. Aflac is specialized in...
-
Inscribe a detailed paper on RFID Solutions and Standards in the Transportation Industry.
-
The following information is from the materials requisitions and time tickets for Job 9-1005 completed by Great Bay Boats. The requisitions are identified by code numbers starting with the letter Q...
-
Find the functions (a) f g, (b) gf, (c) ff, and (d) gg and their domains. f(x) = sin x, g(x) = x 2 + 1
-
Mavis Stores had two billing clerks during the year. Snow worked three months and White worked nine months. As the auditor for Mavis Stores, Jones, CPA, uses attributes sampling to test clerical...
-
A condensed income statement by product line for Celestial Beverage Inc. indicated the following for Star Cola for the past year: Sales .............. $ 290,000 Cost of goods sold ......... 155,000...
-
Quilters Newsletter Magazine gave instructions on making a quilt. The quilt required 4 yards of white-on-white print, 2 yards blue check, yard blue-and-white stripe, 2 yards blue scraps, yard yellow...
-
Serial Entrepreneur, author, and founder of the Entreprenaissance Movement, Creel Price, recounts a time when creativity was needed to fake it to make it. Within months of opening our marketing...
-
When might visitation arrangements trigger an adjustment in support?
-
What views do courts hold on the question of whether adultery can be defined to include extramarital same-sex relationships?
-
How do guidelines treat the situation where an obligor wants to pay less to his first family because he now has a second family with minor children?
-
What is a legal separation? How does an action for separate maintenance differ from a legal separation?
-
What concerns have supporters of no-fault divorce raised about present efforts to reform/eliminate no-fault divorce?
-
FINANCIAL ACCOUNTING: MADE EASY Learning Activity No. 2: Computation of Input and Output Tax Directions: Compute and indicate the following requirements. Show your solution and put your answer on the...
-
Explain the term "Equivalent Units". Why are they calculated in process costing? [4 Marks] [minimum 350 words]
-
Is MBO too limiting in terms of emergent issues and personal creativity? How might you ensure that it does not become so?
-
If Herzberg thinks that an employees base wage and salary is little more than a hygiene factor, why do university students normally rate money as their number one motivator?
-
Tech businesses are among the most innovative organisations because they have to be they face a fastchanging industry of rapidly advancing technology, evolving consumer needs and competitors...
-
A coil of # 12 AWG copper wire wound in a single layer on a cylindrical form so that the mean diameter of each turn is 6.0 in., and it has a resistance of 4.0 . How many turns of wire are there in...
-
Consider the following circuit setup shown below. Determine the voltage drop across the 7 resistor. 120 V DC 12 www 5 H 402 www 50 70 V
-
Find the capacitance that minimizes the source current when connected in parallel with a single-phase induction motor drawing 10 A at a power factor of pf = 0.80 (lagging) when connected to 120 V, 60...
Study smarter with the SolutionInn App