Solve the following questions and provide solutions in excel: Problem-1: Consider the following forecast data for EG
Fantastic news! We've Found the answer you've been seeking!
Question:
Solve the following questions and provide solutions in excel:
Transcribed Image Text:
Problem-1: Consider the following forecast data for EG Bottle Company: Period Forecast May June July August September October Total 50 60 70 90 80 70 420 Given Data Cost Table Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Back ordering cost Beginning inventory Rs 1,500 per unit 40 tank loads/Period Rs 1,400 per tank loads Rs 1,700 per tank loads Rs 1,900 per unit per month Rs 6,000 per month per unit 0 units Develop three aggregate plans to determine the lowest cost of tank loads. Construct a table in Excel sheet for all three cases as shown below: Case 1. The details for strategy 1, where Level production is supplemented by up to 10 tank loads a month from overtime. Develop a level production plan Case 2. Construct an aggregate plan as per strategy 2 where a combination of overtime, inventory and subcontracting is done to minimize the cost: Problem-1: Consider the following forecast data for EG Bottle Company: Period Forecast May June July August September October Total 50 60 70 90 80 70 420 Given Data Cost Table Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Back ordering cost Beginning inventory Rs 1,500 per unit 40 tank loads/Period Rs 1,400 per tank loads Rs 1,700 per tank loads Rs 1,900 per unit per month Rs 6,000 per month per unit 0 units Develop three aggregate plans to determine the lowest cost of tank loads. Construct a table in Excel sheet for all three cases as shown below: Case 1. The details for strategy 1, where Level production is supplemented by up to 10 tank loads a month from overtime. Develop a level production plan Case 2. Construct an aggregate plan as per strategy 2 where a combination of overtime, inventory and subcontracting is done to minimize the cost:
Expert Answer:
Answer rating: 100% (QA)
1 Consider the following forecast data for EG bottle company Regular production cost 1000 per unit Regular production capacity 60 tank loads Overtime ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Imagine you have opened a new business. Describe what you are selling. Answer following questions and provide detail analysis: What are you Variable, Fixed and Mixed Costs? How much it cost you to...
-
Choose one of the following questions and write an essay: You must incorporate both, "How I Met My Husband" and "The Girls in Their Summer Dresses" as well as at least one outside source. Make sure...
-
Read the following questions and respond with one detailed substantial post Your response should be a solid paragraph not just one or two lines In your answer include examples such as short quotes...
-
9 Calculate (3x+x) dx, given the following. Cap [x0x 665 3 xdx= 271 3 19 xdx = 0 2 65 S (3x + x) dx = (Type an integer or a simplified fraction.)
-
Consider the following transportation problem at Frank Timoney Enterprises in Clifton Park, NY. (a) Find an initial solution using the northwest-corner rule. What special condition exists? (b)...
-
A body has a mass of 12.6 kg and a speed of 0.87c. (a) What is the magnitude of its momentum? (b) If a constant force of 424.6 N acts in the direction opposite to the body's motion, how long must the...
-
Horizontal Analysis Total assets were \(\$ 1,000,000\) in \(2019, \$ 900,000\) in 2018 , and \(\$ 950,000\) in 2017. What was the percentage change from 2017 to 2018 and from 2018 to 2019? Was the...
-
America Cola is considering the purchase of a special-purpose bottling machine for $ 65,000. It is expected to have a useful life of 4 years with no terminal disposal value. The plant manager...
-
The following data are for the 2018 fiscal year of Meme-Me Corporation and Sozhal Incorporated. All dollar amounts are in thousands.. Account Title Current assets Mene-Me Corporation. $135,729 Sozhal...
-
Skylar and Walter Black have been married for 25 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Skylar is a stay-at-home parent and Walt is a high school teacher. His W-2...
-
Hey! I need help with (Code HS: 2.14.5 Amusement Park) public class Amusement Park extends Console Program { } int AGE LIMIT = 12; int HEIGHT_LIMIT = 48; public void run() { int age read Int("Enter...
-
Let f(x)= == 3x+7x-6 Find the equations of the horizontal asymptotes and the vertical asymptotes of f(x). If there are no asymptotes of a given type, enter 'NONE'. If there is more than one asymptote...
-
How Company analysis and industry analysis are closely related. Discuss. (b) Outline the dividend discount model (DDM) and evaluate it as a valuation tool.
-
Find the sum of the geometric series, if possible. 9 1)5(2)" n=1 34 8 T 2) n=
-
# 1 Average Velocity Mat and Tam embark on a weekend journey with four stages. First, they drove due East for exactly two and a half hours at a speed of 8 0 kilometers per hour. Then, they visited a...
-
A company which produces railway sleepers for rail infrastructure projects, is seeking to improve its product quality and reliability. The company has provided the following qualitative and...
-
EXERCISES EXERCISE 1A Compare Business Strategy with Military Strategy Purpose This exercise will enable you to compare and contrast military strategy with business strategy because in many ways,...
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
Write each decimal as a fraction or a mixed number. 1. 0.16 2. -12.023
-
Write the whole number in each sentence in standard form. 1. The average distance between the surfaces of the Earth and the Moon is about two hundred thirty four thousand miles. 2. The world's...
-
Office Supplies, Inc. manufactures office products. The company determines that the total cost for manufacturing x file cabinets is given by the polynomial 3000 + 20x. Use this polynomial for...
-
Presented below are selected financial data from The Boeing Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following ratios: receivable turnover, receivable...
-
During 2015, The Mann Corporation borrowed \($500,000\) from The Biltmore National Bank. The loan agreement included a debt covenant restricting the companys level of debt relative to shareholders...
-
The following information is taken from Procter & Gambles 2015 annual report: Calculate the companys actual and sustainable rate of growth in sales for 2015 and 2014. How do the two growth rates...
Study smarter with the SolutionInn App