Welcome to Top Excellors!

Case : Delhi Foods Manisha Pat

Case : Delhi Foods Manisha Pat.

For this problem, please include explanations of variables, objective function and constraints for the solution. A screenshot of how to solve it in excel would also be appreciated

  • Attachment 1
  • Attachment 2

Case : Delhi FoodsManisha Patel recently completed her first week of work as a summer intern at Delhi Foods .Earlier this morning . Manisha’s boss , the director of marketing , asked her to come up with arecommendation on the level of marketing expenses ( advertising and promotion expenditures )for a line of frozen Indian dinners as it enters its seventh year in the marketplace . Exhibit 8 . 1 .which Manisha received from her boss , contains an accounting summary of essential productcosts and revenues in the first 6 years . during which there has been some trial – and – error exper -Imentation with marketing policies . For year ] . the table shows projections for the coming yearEXHIBIT 8.1Summary of Product Costs and RevenuesYear267Demand ( cartons )3. 2003. 4003.50.03. 60.03. 8004. 4004. 700Revenue $ ( 090 )62. 00063. 0.0066. 00 075. 0.0086. 00098.000105, 000ProductionMaterials27. 00029. 00030. 00 035. 00039. 00033. 00035, 000Other variables1 . 7002.2002.80 03.50.02, 40010. 8001 1 , 60.0Fixed4. 5004. 7004. 90.05. 0.005. 30.05. 6005. 90.0MarketingAdvertising*10. 30011 . 70015. 0.0 016. 20.017. 80022. 00024, 0.00Promotion9.0006.0.004. 0.0 01 1. 00012,00013.00014, 0:00Overhead6. 0.006. 0.005. 0.0 05. 0.005. 0.005.0.006.000Operating margin3.5003. 40.04. 30.0( 70 0 )4. 5008. 6008.50.0

Case : Delhi Foods Manisha Pat

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.