Question: This is Excel post Question We wish to produce 5000 cardboard boxes Each cardboard box must hold 100,000 cm3 (volume) Box width must be twice

"This is Excel post Question"

We wish to produce 5000 cardboard boxes
Each cardboard box must hold 100,000 cm3 (volume)
Box width must be twice the height
Cardboard costs $0.002 per cm2
Find the minimum total cost we could produce all these cardboard boxes?

Hint: Use the Excel solver to find the length, width and height that give you the minimum possible surface area.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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 Databases Questions!

Q:

Determine the acceleration of the shaft B for = 60 if the crank OA has an angular acceleration = 8 rad/s2 and an angular velocity = 4 rad/s at this position. The spring maintains contact between...

Q:

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

Q:

1 WILMINGTON UNIVERSITY LIBRARY Business Continuity Plan (BCP) and Disaster Recovery Plan (DRP) 2 WILMU LIBRARY SERVICES 20,000 student population served 13 physical locations of access to university...

Q:

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Q:

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

Q:

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

Q:

ACC 442 ADVANCED FINANCIAL REPORTING 2 YR POST DIP QUESTION-1 - 2 YR. POST DIP.pdf - Adobe Reader File Edit View Window Help Open 1 / 6 62.8% Tools Fill & Sign Comment Sign In Export PDF Adobe Export...

Q:

MBA Student Satisfaction Case DISCUSSION How do marketing campaigns influence customers' perception of a product? Organizations often collect customer data to help answer this question. For example,...

Q:

Fall 2020 ACC250 Term Proje Accounting Cyc Excel-based Project Data/Instructions Sandra Martin owns and operates Accounting Solutions, a first-year service business. The attached Excel file includes...

Q:

Sandra Martin owns and operates Accounting Solutions, a first-year service business. The attached Excel file includes the unadjusted trial balance for 12/31/2019. The following additional facts are...

Q:

How do marketing campaigns influence customers' perception of a product? Organizations often collect customer data to help answer this question. For example, a University in Boston is concerned with...

Q:

Selender has 200 million dollars under management. He is long 100,000 shares of stock A which is priced at 20 dollars per share. He is short 50,000 shares of Stock B, which is trading at 40 dollars...

Q:

Calculate WACC estimate for Clorox, the last 3 years from 2020-2018.

Q:

_ _ _ _ _ are bond investments that a company intends to hold and also has the ability to hold until their maturity date. Trading securities Available - for - sale securities Held - to - maturity...

Q:

For the reaction: Ca(OH)2 (s) + H2SO4 (l) = CaSO4 (s) + 2H2O (l) H = -94.3 kJ/mol How many kJ of heat are liberated or absorbed when 31.12 g of Ca(OH)2 (74.0 g/mol) are reacted with 96.23 g of H2SO4...

Q:

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

Q:

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

Q:

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...