Company produces canned cat food called cat chow

Assignment Help Operation Management

Reference no: EM132108597

Bark’s Pet Food Company produces canned cat food called Cat Chow and canned dog food called Dog Dinner. The company produces the pet food from beef, ground fish, and a cereal additive. Each week the company has 600 pounds of beef, 800 pounds of ground fish, and 1,000 pounds of grain additive available to produce both kinds of pet food. Cat Chow must be at least 50% fish, and Dog Dinner must be at least 50% beef. The company has 2,250 16-ounce cans available each week. A can of Cat Chow earns $0.80 in profit, and a can of Dog Dinner earns $0.96 in profit. The total fixed costs for running Bark’s per week is $1,400. 1. Model this linear program in Excel and name the worksheet “LP Problem”. Use Excel Solver to determine the optimal recipe of both Cat Chow and Dog Dinner, how many cans of Cat Chow and Dog Dinner to produce each week, and what the maximum weekly profit will be.

Reference no: EM132108597

Questions Cloud

Explain why the opportunity is promising : Are you motivated to succeed in business? It is time to develop a mini business plan! Prepare a 15-slide PowerPoint presentation. The PowerPoint presentation.

Types of technology used for team meetings and communication : HRMD665 Tell us about a recent team you have been involved with at work. Describe the function of the team, the demographics, knowledge and skills different.

Analyse and understand the driving forces of perception : Consumer Behaviour and Marketing Psychology - critically analyse and understand the driving forces of perception, attitudes, motivation, group and individual

Change for entrepreneurship to flourish in the future : What conditions are necessary or need to change for entrepreneurship to flourish in the future?

Company produces canned cat food called cat chow : Bark’s Pet Food Company produces canned cat food called Cat Chow and canned dog food called Dog Dinner.

How does personal identity play a role with the two groups : Discuss similarities and differences between these two groups. How does personal identity play a role with these two groups?

Reflect on your commitment to operative co-creatively : Reflect on your commitment to operative “co-creatively” and generate positive change in the world.

Define outcome of a consulting recommendation : Change has been emphasized in this course as the most likely outcome of a consulting recommendation. Identify some of the common comments in reaction.

Discuss institutional racism and give examples : Explain, in detail Plessy vs Ferguson. Also discuss institutional racism and give examples. what were his goals for the Western Reserve?

User Account

All Pages