Business, 11.10.2020 23:01, elijahjacksonrp6z2o7

The Shop at Home Network sells various household goods during live television broadcasts. The company owns several warehouses to hold many of the goods it
sells, but also leases extra warehouse space when needed. During the next five
months the company expects that it will need to lease the following amounts of extra
warehouse space:
Month 1 2 3 4 5
Square Feet Needed 20,000 30,000 40,000 35,000 50,000
At the beginning of any month the company can lease extra space for one or more
months at the following costs:
Lease Term (months) 1 2 3 4 5
Cost per Sq. Ft. Leased $55 $95 $130 $155 $185
So, for instance, at the start of month 1 the company can lease as much space as it
wants for 4 months at a cost of $155 per square foot. Similarly, at the start of month 3
it can lease any amount of space for 2 months at a cost of $95 per square foot. The
company wants to determine the least costly way of meeting its warehousing needs
over the coming 5 months.
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem and solve it using Solver.
c. What is the optimal solution?
d. How much would it cost the company to meet its space needs if in each month it
leases for one month exactly the amount of space required for the month

Answers: 3

Show answers

Other questions on the subject: Business

Business, 22.06.2019 06:20, kingyogii

At a small store, a customer enters the front door on average every 8 minutes. a prior study indicated that the time between customers entering the front door during weekdays follows an exponential distribution. what is the probability that the time between customers entering the store on a weekday will be less than or equal to 7? select one: a. 62 b. 43 c. 1/8 d. 7/8 e. 58

Answers: 1

continue

Business, 22.06.2019 12:10, destinycasillas

Profits from using currency options and futures. on july 2, the two-month futures rate of the mexican peso contained a 2 percent discount (unannualized). there was a call option on pesos with an exercise price that was equal to the spot rate. there was also a put option on pesos with an exercise price equal to the spot rate. the premium on each of these options was 3 percent of the spot rate at that time. on september 2, the option expired. go to the oanda. com website (or any site that has foreign exchange rate quotations) and determine the direct quote of the mexican peso. you exercised the option on this date if it was feasible to do so. a. what was your net profit per unit if you had purchased the call option? b. what was your net profit per unit if you had purchased the put option? c. what was your net profit per unit if you had purchased a futures contract on july 2 that had a settlement date of september 2? d. what was your net profit per unit if you sold a futures contract on july 2 that had a settlement date of september 2

Answers: 1

continue

Business, 22.06.2019 17:30, lanamiami

After the embarrassing sign incident at the restaurant you own, you decide to offer employees a six-week fundamental writing skills workshop. a local business communication instructor, who has experience teaching writing skills at treleaven community college, will facilitate the sessions. to encourage employees to attend these optional sessions, write an email that explains why you’re offering the workshop and why employees should participate.

Answers: 2

continue

Business, 22.06.2019 20:00, javonteoshamccaliste

Lillypad toys is a manufacturer of educational toys for children. six months ago, the company's research and development division came up with an idea for a unique touchscreen device that can be used to introduce children to a number of foreign languages. three months ago, the company produced a working prototype, and last month the company successfully launched its new device on the commercial market. what should lillypad's managers prepare for next? a. increased competition from imitators b. a prolonged period of uncontested success c. a sharp decline in demand for the product d. a difficult struggle to move from invention to innovation

Answers: 2

continue

Do you know the correct answer?

The Shop at Home Network sells various household goods during live television broadcasts. The compa...