Question: i need EXCEL answer + explaination and steps how to solve on excel Q2 Question 2 10 Points Students who are trying to raise funds

i need EXCEL answer + explaination and steps how to solve on excel

Q2 Question 2 10 Points Students who are trying to raise funds have an agreement with a local pizza chain. The chain has agreed to sell them pizzas at a discount, which the students can then resell to families in the local community for a profit. It is expected that of the 500 families in the community, at most 70% will buy pizza. Based on a survey of their personal preferences, the students believe that they should order no more than 120 cheese pizzas, no more than 150 pepperoni pizzas, and no more than 100 vegetarian pizzas. They also want to make sure that at least 20% of the total pizzas are cheese and at least 50% of the pizzas are pepperoni. They make a profit of $1.45, $1.75, and $1.98, respectively, for each cheese, pepperoni, and vegetarian pizza they resell. Formulate (but do not solve) an LP for this problem to determine the number of pizzas of each type that they should buy

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 General Management Questions!

i need excel answer + explaination on how we got the answers Students who are trying to raise funds have an agreement with a local pizza chain. The chain has agreed to sell them pizzas at a discount,...

Hello Finstat. I have really appreciated your help so far. Can you help with the attached? From what I can tell and what the instructor has told us is that this is less involved than the previous...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

I need help from a Financial expert who is very familiar with exchange rate exposure & payout policy.I will adjust the price as you suggest. For some reason I am not able to do it here. Please be...

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

Dong Lee Math-138 Professor Deshpande 10-16-16 Project Part 2 Research Proposal: Introduction: The first variables I plan to study are the hours you spend on the smartphone daily and the monthly...

Due to the changing environment and external triggers, contingency planning is necessary. What qualities make a future issue a ?trigger?? Consider you are on the strategic planning team for a soft...

Through the use of strategic alternatives, companies may compete in a marketplace, achieve its vision, or if no vision has been articulated, decide where it might go and what it might achieve....

Dear Tutor, I need some help with my Accounting assignment. Let you know that company A is Michael Hill (MHJ), and company B is Blackmores (BKL) I have already attached three documents: 1) ACCT7101...

Explain the accounting differences between a fair value hedge and a cash flow hedge.

Give a brief summary of each and explain why they are the mostimportant Benefit 3 A higher minimum wage could reduce government welfarespending. If low-income workers earned more money, their...

Hike Hn' Run has decided to produce 288,000 pairs of socks at a uniform rate throughout 2020. The sales department of Hike n' Run has estimated sales for 2020 according to the following schedule:...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...