Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Steve Your Own Question

Steve, MBA

Category: Homework

Satisfied Customers: 23339

Experience: MBA

26942375

Type Your Homework Question Here...

Steve is online now

Financial information (a budget showing product launch expenses

This answer was rated:

★★★★★

Financial information (a budget showing product launch expenses and a unit forecast by quarter for 3 years)

My new product launch is prepackaged meals which will be distributed through Wal-Mart domestically and internationally(Mexico). Wal-Mart has promised to buy 1580 cases per store at 36 dollars/case. In the US, they have 3,499 stores. In Mexico, they have 633 stores. There are 12 meals per case.

Food cost comes in at 33% i.e. $24/case cost and $36/case sold to Wal-Mart Labor cost is 21% Advertising/promotion cost budgeted at 4% of sales We expect to increase sales by 10% each year. Can You show show this in excel plus breakeven pt?

Yes, I need it by 5pm CST 11/1 needs to show three years The food cost was derived by sales of 235,028,160 minus cost of 156,685,440 = 78,342,720/235,028,160=.33