Corporate Finance MGMT E2700 Fall 2020 Case assignment Professor Gandevani Page 1 of 9 Sunny Corporation Fixed vs. Seasonal Monthly Production Sunny Corporation is a manufacturing company. Due to the...

1 answer below »

View more »
Answered Same DayNov 07, 2021

Answer To: Corporate Finance MGMT E2700 Fall 2020 Case assignment Professor Gandevani Page 1 of 9 Sunny...

Sumit answered on Nov 09 2021
141 Votes
Table 1
    Table 1    Sales Forecast in Units
    1st QTR    Oct 2020    100
        Nov    75
        Dec    50
    2nd QTR    Jan 2021    0
        Feb    0
        Mar    250
    3rd QTR    Apr    550
        May    900
        Jun    1100
    4th Qtr    July    1000
        Aug    550
        Sep    200
Table 2
    Table 2    Production Schedu
le and Inventory (equal monthly production)
        Beginning    Production    Sales    End    Inventory    Sales
        Inventory    This        Inventory    $2,000    $3000
            Month            per unit    in $
    October 2020    400    100    100    400    $800,000    $ 300,000
    November     400    75    75    400    $800,000    $ 225,000
    December     400    50    50    400    $800,000    $ 150,000
    January     400    0    0    400    $800,000    $ - 0
    February     400    0    0    400    $800,000    $ - 0
    March     400    250    250    400    $800,000    $ 750,000
    April     400    550    550    400    $800,000    $ 1,650,000
    May     400    900    900    400    $800,000    $ 2,700,000
    June     400    1100    1100    400    $800,000    $ 3,300,000
    July     400    1000    1000    400    $800,000    $ 3,000,000
    August     400    550    550    400    $800,000    $ 1,650,000
    September     400    200    200    400    $800,000    $ 600,000
Table 3
    Table 3    Sales Forecast, Cash Receipts and Payments, and Cash Budget
                October    November    December    January    February    March
            Unit    2020                        April    May    June    July    August    September
            Price/Cost    Sales Forecast                        Sales Forecast
    Sales (units)             100    75    50    0    0    250    550    900    1100    1000    550    200
    Sales unit price:        $3,000    $300,000    $225,000    $150,000    $0    $0    $750,000    $1,650,000    $2,700,000    $3,300,000    $3,000,000    $1,650,000    $600,000
                Cash Receipts Schedule                        Cash Receipts Schedule
     Cash         50%    $150,000    $112,500    $75,000    $0    $0    $375,000    $825,000    $1,350,000    $1,650,000    $1,500,000    $825,000    $300,000
    From prior month’s sales*         50%    $ 375,000    $150,000    $112,500    $75,000    $0    $0    $375,000    $825,000    $1,350,000    $1,650,000    $1,500,000    $825,000
       Total cash receipts             $525,000    $262,500    $187,500    $75,000    $0    $375,000    $1,200,000    $2,175,000    $3,000,000    $3,150,000    $2,325,000    $1,125,000
                Cash Payments Schedule                        Cash Payments Schedule
    Production in units             100    75    50    0    0    250    550    900    1100    1000    550    200
    Production costs        $ 2,000.00    $ 200,000.00    $ 150,000.00    $ 100,000.00    $ - 0    $ - 0    $ 500,000.00    $ 1,100,000.00    $ 1,800,000.00    $ 2,200,000.00    $ 2,000,000.00    $ 1,100,000.00    $ 400,000.00
    Fixed overhead             $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00    $ 200,000.00
    Dividends            0    0    0    0    0    0    0    0    0    0    $1,000,000    0
    Other seasonal...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30