Running Head: CHEF’S TOOLKIT Harvard Case Solution & Analysis

Appendices

Exhibit 1: Expected Scenario Production Schedule and Projected Financial Statements

Projected Production Schedule (Based on 10,000 units/month sales)
  Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Jul Total
Production    40,000    29,500   24,000   15,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   188,500
Less: Sales    10,000    10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   120,000
Promotion         500         500        500        500          -          -          -          -          -          -          -          -       2,000
Inventory Total    29,500    19,000   13,500     4,500          -          -          -          -          -          -          -          -     66,500
Home    10,000    10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   10,000   120,000
Warehouse    19,500      9,000     3,500  -  -  -  -  -  -  -  -  -     32,000
Projected Monthly Cash Flows
Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Jul Total
A/R COLLECTIONS
31-60 Days  -      9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100   100,100
61-90 Days  -     9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100     9,100     91,000
TOTAL  -      9,100   18,200   18,200   18,200   18,200   18,200   18,200   18,200   18,200   18,200   18,200   191,100
CASH OUTFLOWS
Production (mold manufacturing)    28,000    20,650   16,800   10,500     7,000     7,000     7,000     7,000     7,000     7,000     7,000     7,000   131,950
Depreciation (Single Mold) 5800.00 4277.50 3480.00 2175.00 1450.00 1450.00 1450.00 1450.00 1450.00 1450.00 1450.00 1450.00     27,333
Depreciation (Package Mold)         680         502        408        255        170        170        170        170        170        170        170        170       3,205
Depreciation (Office Equipment)           10           10          10          10          10          10          10          10          10          10          10          10          120
Sales Expenses         646         646        646        646          -          -          -          -          -          -          -          -       2,584
Packaging    17,200    12,685   10,320     6,450     4,300     4,300     4,300     4,300     4,300     4,300     4,300     4,300     81,055
Delivery         850         850        850        850        850        850        850        850        850        850        850        850     10,200
General            -
Warehouse         230         230        230          -          -          -          -          -          -          -          -          -          690
Taxes Payable  -   (6,150)   (2,909)      (537)        884        884        884        884        884        884        884     (3,408)
Accounts Payable    12,075  -  -  -  -  -  -  -  -  -  -  -     12,075
TOTAL    65,491    39,850   26,594   17,977   13,243   14,664   14,664   14,664   14,664   14,664   14,664   14,664   265,803
NET CASH FLOW  (59,001)  (25,961)   (4,496)     2,663     6,587     5,166     5,166     5,166     5,166     5,166     5,166     5,166   (44,046)
Required Financing:  (59,001)  (25,961)   (4,496)     2,663     6,587     5,166     5,166     5,166     5,166     5,166     5,166     5,166   (44,046)
Beginning    85,000    25,999          38   (4,458)   (1,795)     4,792     9,958   15,124   20,290   25,456   30,622   35,788     85,000
Financing Shortfall    25,999           38   (4,458)   (1,795)     4,792     9,958   15,124   20,290   25,456   30,622   35,788   40,954     40,954

 

Projected Income Statement
 
Sales 191100
COGS:
  Production 131950
  Packaging 81055
Depreciation:
  Single Mold 27332.5
  Double Mold 0
  Package Mold 3204.5
Subtotal
  Less: Promotional Units 2584
Subtotal
  Less: Ending Inventory 85918
Gross Profit
  30892
Operating Expense:
  General -
  Delivery 10200
  Warehouse 690
  Promotion -
  Depreciation (Office Equipment) 120
Total 11010
Net Profit (Loss) 19882
Estimated Income Tax -3408
 
Net Earnings 23290

 

Projected Balance Sheet
CURRENT ASSETS
Cash           345
Accounts Receivable    191,100
Inventory      85,918
Total    277,363
Equipment
Cost      32,795
Less: Accumulated Depreciation      30,657
Net        2,138
Patent      13,800
Total    293,301
LIABILITIES
Estimated Tax       (3,408)
Accounts Payable      12,075
Total Liabilities        8,667
EQUITY
Common Stock      34,520
Retained Earnings      23,290
Total Equity      57,810
Required Financing     (59,001)
Total  (with B/F)    293,301

 

Running Head CHEF’S TOOLKIT Harvard Case Solution & Analysis

Exhibit 2: Pessimistic Scenario Production Schedule and Projected Financial Statements

Projected Production Schedule (Based on 5,000 units/month sales)
  Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Jul Total
Production    40,000    34,500    34,000    15,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    203,500
Less: Sales      5,000      5,000      5,000      5,000      5,000      5,000      5,000      5,000      5,000      5,000      5,000      5,000      60,000
Promotion         500         500         500         500           -           -           -           -           -           -           -           -        2,000
Inventory Total    34,500    29,000    28,500      9,500      5,000      5,000      5,000      5,000      5,000      5,000      5,000      5,000    141,500
Home    10,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    10,000    120,000
Warehouse    24,500    19,000    18,500  -  -  -  -  -  -  -  -  -      62,000
Projected Monthly Cash Flows
Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Jul Total
A/R COLLECTIONS
31-60 Days  -      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      50,050
61-90 Days  -      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      4,550      45,500
TOTAL  -      4,550      9,100      9,100      9,100      9,100      9,100      9,100      9,100      9,100      9,100      9,100      95,550
CASH OUTFLOWS
Production (mold manufacturing)    28,000    24,150    23,800    10,500      7,000      7,000      7,000      7,000      7,000      7,000      7,000      7,000    142,450

This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.

Related Case Solutions & Analyses:

PluroGen Therapeutics Why Implementing Corporate Innovation is So Difficult A New Executive Director Partners Healthcare System (PHS): Transforming Health Care Services Delivery Through Information Management Fairchild Water Technologies ITC LTD.: TOWARD A TRIPLE BOTTOM LINE PERFORMANCE Case Study: Analysis NIMBLE STORAGE Default ThumbnailDisturbed Sensory (Auditory) Perception Default ThumbnailCulture – USA Default ThumbnailManaging Innovation at Nypro, Inc.

Hire us for Originally Written Case Solution/ Analysis


Buy Now

Like Us and Get Updates:

Harvard Case Solutions

Search Case Solutions

Categories

More From Harvard Case Study Analysis Solutions

Contact us:


Email: order@thecasesolutions.com
WhatsApp:
Terms of Service
Refund Policy
Privacy Policy

Check Order Status

Service Guarantee
Payment Option

How Does it Work?

Why TheCaseSolutions.com?

- Inhouse team of MBAs and CFAs (not reliant on freelancers)

- Biggest academic writing team on internet (220+ MBAs/ CFAs)

- Affordable prices

- Religiously meeting the deadlines

- Strong checks and systems in place

- Competent agents on live chat (best in the industry)

- Absolutely no plagiarism

Sitemap

We are the Number 1 Case Study Solution Provider In the Case Study Help Niche
Share This

SALE SALE

Save Up To

30%

IN ONLINE CASE STUDY

FOR FREE CASES AND PROJECTS INCLUDING EXCITING DEALS PLEASE REGISTER YOURSELF !!

Register now and save up to 30%.
Register Now