Case : Delhi Foods Manisha Patel recently completed her first week of work as a summer intern at Delhi Foods . Earlier this morning . Manisha's boss...
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
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
Show more
