; Rapido de Marie-France
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Rapido de Marie-France

VIEWS: 2 PAGES: 14

  • pg 1
									Decision variables
                            1        2           3      4   5   6
NbEmb                       1        2           2      2   1   1
NbMaP                       1        1           1      1   1   1

Result variables
Rev Net Total        29,304 $

Parameters to analyse
Renov                       0        0           1      0   0   0




802c2d48-6b22-4b6e-9a82-e8275d83de5d.xlsx   Interface           Page 1 de 14
Application                0          1           2             3          4          5           6

NbEmpBeforeAdj                         5           5             6          7          8           8
NbEmbHired                             1           2             2          2          1           1
NbEmpFired                            -1          -1            -1         -1         -1          -1
NbEmp                      5           5           6             7          8          8           8

NbEmp                                 5           6             7          8          8           8
NbClEmp                              50          50            50         50         50          50
ServiceCapacity                     250         300           350        400        400         400

NbCl                                310         330            280       310        340         260
RenoIndicator                         0           0              1         0          0           0
PctReduction                       50%         50%            50%       50%        50%         50%
NbClTo Reduce                         0           0            140         0          0           0

NbCl                                310         330            280       310        340         260
NbClToReduce                          0           0           -140         0          0           0
NbClPresent                         310         330            140       310        340         260

NbCl                                310         330           140        310        340         260
ServiceCapacity                     250         300           350        400        400         400
NbClServed                          250         300           140        310        340         260

NbClServed                          250          300           140        310        340        260
RevNetCl                           3.58         3.58          3.58       3.58       3.58       3.58
RevBeforeSal                     895.00     1,074.00        501.20   1,109.80   1,217.20     930.80

NbEmp                                 5           6              7         8          8           8
Wages                             60.00       60.00          60.00     60.00      60.00       60.00
DailySalary                      300.00      360.00         420.00    480.00     480.00      480.00

ReBeforeSal                       895.00    1,074.00     501.20      1,109.80   1,217.20     930.80
DailySalary                      -300.00     -360.00    -420.00       -480.00    -480.00    -480.00
RevAfterSal                       595.00      714.00      81.20        629.80     737.20     450.80

RevAfterSal                       595.00    714.00        81.20    629.80    737.20          450.80
NbDays                                21        20           23        21        22              22
MonthlyRevenue                 12,495.00 14,280.00     1,867.60 13,225.80 16,218.40        9,917.60

NbrHired                              1           2              2         2          1           1
HireCost                         300.00      300.00         300.00    300.00     300.00      300.00
MCostHire                        300.00      600.00         600.00    600.00     300.00      300.00

NBFired                               1           1              1         1          1           1
FireCost                         200.00      200.00         200.00    200.00     200.00      200.00
MFireCost                        200.00      200.00         200.00    200.00     200.00      200.00

MonthlyRevenue                 12,495.00 14,280.00      1,867.60 13,225.80 16,218.40        9,917.60
MFixExp                        -5,800.00 -5,800.00     -5,800.00 -5,800.00 -5,800.00       -5,800.00
MHireCost                        -300.00   -600.00       -600.00   -600.00   -300.00         -300.00
MFireCost                        -200.00   -200.00       -200.00   -200.00   -200.00         -200.00



802c2d48-6b22-4b6e-9a82-e8275d83de5d.xlsx     Application                                     Page 2 de 14
MNetRev                        6,195.00     7,680.00   -4,732.40   6,625.80   9,918.40   3,617.60




802c2d48-6b22-4b6e-9a82-e8275d83de5d.xlsx     Application                                  Page 3 de 14
Parameters
NbClEmp                  50
Wages                    60
NetRevPerCl            3.58
NbEmp Initial             5
EmbCost                 300
PMCost                  200
Monthly fee           5800
ProductReduc          50%

Temporal parameters
                         1          2          3         4     5     6
NbDay                   21         20         23        21    22    22
NbClDay                310        330        280       310   340   260




802c2d48-6b22-4b6e-9a82-e8275d83de5d.xlsx   Services                 Page 4 de 14
        Each month



                     Service
                     Capacity
NbCl
Emp

                                NbEmp




                                          (t-1)

              NbPM

                                NbEmp
PMCos                           BeforeA
t                               djust.


               MonthlyC
               ostPM
           Wages




                                                        NbCl
                                                        Reduct
                              NbCl
                              Served

                                           NbCl
          Wages
                                           Real
          Quot



                              RevAv
                              Wag
NbEmb




                      RevAp                  MonthlyR
                      Wag                    ev


Monthly
Cost
Emb


                   Monthly             MonthlyNe
                   Cost                tRev
                   GestPers
Emb
Cost
     Prct
     Reduc




NbCl
                    Renov
Reduct




                  NbCl




                              NetRe
                              vCl


             Nb



                            TotalNetRe
                            v




                               Monthl
                               y Fee
Model               0

NbEmpBeforeAdjust
NbEmb
NbPM
NbEmp               =NbEmp_Initial

NbEmp
NbClEmp
Capacity

NbCl
Renov
PrctReduct
NbClReduct

NbCl
NbClReduct
NbClReal

NbCl
Capacity
Nb Cl Served

Nb Cl Served
NetRevCl
AvRevWag

NbEmp
Wages
Wages Quot

AvRevWag
Wages Quot
RevApWag

RevApWag
NbDays
MonthlyRev

NbEmb
EmbCost
MonthlyCostEmb

NbPM
PMCost
Monthly PMCost

Monthly Rev
Monthly Fee
Monthly Cost Emb
Monthly Cost PM
MonthlyNetRev
1

=B6
=Interface!B3
=-Interface!B4
=SUM(C3:C5)

=C6
=NbClEmp
=C8*C9

=Services!B14
=Interface!B10
=PrctRédux
=C12*C13*C14

=Services!B14
=-C15
=C17+C18

=C19
=C10
=MIN(C21:C22)

=C23
=RevNetCl
=C25*C26

=C6
=Salaire
=C30*C29

=C27
=-C31
=SUM(C33:C34)

=C35
=Services!B13
=C37*C38

=C4
=CoutEmb
=C42*C41

=Interface!B4
=CoutMaP
=C46*C45

=C39
=-FraisMensuels
=-C43
=-C47
=SUM(C49:C52)

								
To top