Question: You are required to prepare a business model using Excel to solve the business problem using Data Table and Solver. CASE 1: A fabric company

You are required to prepare a business model using Excel to solve the business problem using Data Table and Solver. CASE 1: A fabric company produces sheets of fabric in three different sizes, 100 inch, 80 inch and 50 inch. However, the demand for the sheets is in smaller sizes, 45 inch, 30 inch and 15 inch. The demand for each fabric is 150, 200 and 175 units respectively. How should the company cut the fabric to minimize waste?Please provide the answer in excel sheet.

Step by Step Solution

★★★★★

3.41 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To create a business model in Excel to solve this problem you can use the Data Table and Solver tools Here is one approach to set up the model Create a spreadsheet with the following columns Size Demand Production Waste In the Size column list the three smaller sizes 45 inch 30 inch 15 inch and the three larger sizes 100 inch 80 inch 50 inch In the Demand column list the demand for each size 150 units 200 units 175 units In the Production column enter formulas to calculate the number of large sheets needed to meet the demand for each small size For example to meet the demand for 150 units of the 45inch size you would need 3 large 100inch sheets 450 inches or 4 large 80inch sheets 320 inches In the Waste column enter formulas to calculate the amount of waste for each large size For example if you use 3 large 100inch sheets to meet the demand for the 45inch size you would have 50 inches of waste 100 inches 45 inches 55 inches Use the Data Table tool to generate a table that shows the total waste for each combination of large sheets used to meet the demand for the small sizes Use the Solver tool ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

In this task, you are required to prepare a tax case analysis based on the recent controversial hearing on ABS-CBN's franchise renewal in the Philippines. You are required to state the facts and make...

You are required to prepare two written responses: 1) tax file memorandum and 2) client letter. For the tax memorandum file, use exhibit 2.9 on page 2-27 for an example

You are required to prepare a report on Progressive Insurance Claims Department. This report also includes. New Claims division Aids in Customers Needs Vision and Business Model How the...

can anyone help me with my assignment, which is consist part 1 and 2. but i already done the part 1 and now i need someone to settle this out. here i attach the question including my answer for part...

Department of Operations Management \& Business Statistics POMG6724: Analytics for Business Decisions Group Project Assessment (40\%) Instructions Project deliverables For this project, each group...

need help fingering out how to solve my answers for the cells that are highlighted in blue. Format Organize instructions Data ENTERANSWERS MNOP 1 2 Short-Term Business Decisions Using Excel to...

Cars-to-Dealers Logistics Inc. is the exclusive logistics provider for the Summit Motor Co. and has responsibility for transporting cars from Summit's 3 manufacturing plants in Toledo, OH; Charlotte,...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

In the vibrant world of fashion, a renowned company grappled with inventory challenges, seeking optimization through linear programming. A group of astute students, entrusted with this task, aimed to...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

On January 1 of the current year, Baker Corp. purchased $70,000 of Chocolate Inc. bonds. These bonds pay 5% interest annually on December 31 and mature in ten years on December 31. The investment is...

Why do we need to calculate beginning Retained Earnings and beginning NCI when preparing consolidated financial statements using the worksheet method.

Company A shares are currently trading at $50 per share. A survey of Wall Street analysts reveals that EPS expectations for Company A for the full year 2014 are $2.50 per share. Company A has 300...

Write a paper on rhetorical analysis analyze rhetorical elements use logos, ethos, and pathos as means of persuasion;

Write an essay on Rhetorical analysis about two documents about mechanical engineering For this essay, you will compare and analyze two documents that involve writing in your field for two different...

Blood Types A medical researcher wishes to see if hospital patients in a large hospital have the same blood type distribution as those in the general population. The distribution for the general...

dy Given the equation x + 2xy + y* = 2, evaluate Assume that the equation implicitly defines y as a differentiable function of x. dx 4 If F(x,y) = Vx +2xy +y* - 2= 0, then F, =

A company's current inventory consists of 5,000 units purchased at $6 per unit. Replacement cost has now fallen to $5 per unit. What is the entry the company must record to adjust inventory to...

Identify the stakeholders for your project is building a Daycare Center in a Community College, and describe how you will engage them. Discuss a stakeholder register.

Shown below is a typical cost-volume-profit Required: (a) Explain to a colleague who is not an accountant the reasons for the change in result on this cost-volume-profit chart from a loss at point...

A company is considering the possibility of purchasing from a supplier a component it now makes. The supplier will provide the components in the necessary quantities at a unit price of 9....

A company using process costing manufactures a single product which passes through two processes, the output of process 1 becoming the input to process 2. Normal losses and abnormal losses are...

=+13. Integrated circuits (ICs) consist of thousands of small circuits, electronic subcomponents (e.g., resistors), and connections. An important factor in the manufacture of ICs is the yield, the...

=+of pinholes on an IC, its entire surface was first divided into 10 equal areas (strata), each of which was further subdivided into 1000 smaller rectangles that served as the elements to be sampled....

=+c. Using the sample sizes in part (b), the results of the study showed the following numbers of pinholes per sample: Sample #: 1 2 3 4 5 6 7 8 9 10 Pinholes: 5 4 7 6 3 9 5 6 2 8 Calculate the...