100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Other

Decision Maker TopSim

Rating
-
Sold
2
Pages
68
Uploaded on
22-08-2021
Written in
2020/2021

This intelligent Excel sheet will calculate everything you need to calculate for TopSim automatically. Just fill in the yellow highlighted fields, and the sheet will show you the outcome (expected revenue, number of machines needed, number of employees needed, etc.). Try out what could work and find the optimal decision. With this sheet, you won't waste money or have staff shortcomings. By entering your expected number of Sales, the sheet will give you all information you have to type in for the decisions. Includes: - Overview of your final decisions to type into TopSim -Indices (Qualification Index, Quality Index) - Sales Planning (Number of Employees, Hiring/Dismissal Costs, Wages and Total Costs) - Production Planning (Number of Machines needed, Number of Shifts needed, Number of Production Employees needed, Costs per Plant, Total Costs) - HRM Planning (Number of Employees you have to Hire/Dismiss, Training, Expenses) - Cost Accounting (Cost per Plant, Total Costs, Expected Revenue, Shows all cost factors) - Logistics Planning (Units in Stock, Units needed, Optimal Order quantity, Logistic Costs, Warehouse costs per warehouse, Total Logistics and Warehouse costs) - Financial Planning (Short Term loans vs. Long Term loans, Loans needed, Yields, Securities) - Cost Accounting Costs of Goods Sold - Income Statement - Cash Flow Statement

Show more Read less
Institution
Module











Whoops! We can’t load your doc right now. Try again or contact support.

Written for

Institution
Study
Module

Document information

Uploaded on
August 22, 2021
Number of pages
68
Written in
2020/2021
Type
Other
Person
Unknown

Subjects

Content preview

Index Factors Calculator Current Qualification Index
Plant 1
Qualification Index of Workforce Training Expenditure 0.0545 1.1

Plant 2
Qualification Index of Workforce Training Expenditure 0.0584 1.12

Main Plant
Qualification Index of Workforce Training Expenditure 0.0359 1.11

Market Quality 0.284

,New Qualification Index

1.15


1.18



1.14592

1.22

,Plant 1
Expenditure No. of Employees Expenditure Per Employee
150000 19 7894.7
150000 30 5000.0
100000 19 5263.2
50000 21 2381.0
50000 19 2631.6
100000 19 5263.2
150000 19 7894.7
150000 29 5172.4
100000 18 5555.6
50000 20 2500.0
50000 18 2777.8

100000 18 5555.6
300000 57 5263.2
300000 86 3488.4
200000 58 3448.3
100000 64 1562.5
10000 57 175.4
110000 56 1964.3

, Quality Management Expenditure vs Difference Between TQ and PQ
Qualification Index Difference TQ PQ Expenditure Difference
1.11 0.09 0.94 1.21 1050000 0.27
1.07 0.05 0.97 1.12 250000 0.15
1.07 0.05 0.94 1.1 280000 0.16
1.04 0.02 0.94 1.07 200000 0.13
1.04 0.02 0.96 1.11 250000 0.15
1.07 0.05 0.94 1.04 125000 0.1
1.1 0.08
1.07 0.05
1.08 0.06
1.04 0.02
1.04 0.02

1.08 0.06
1.13 0.11
1.08 0.06
1.1 0.08
1.08 0.06
1.05 0.03
1.06 0.04
$30.83
Get access to the full document:

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Get to know the seller
Seller avatar
xsaturn5x

Get to know the seller

Seller avatar
xsaturn5x Hanzehogeschool Groningen
Follow You need to be logged in order to follow users or courses
Sold
2
Member since
4 year
Number of followers
2
Documents
2
Last sold
3 year ago

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these revision notes.

Didn't get what you expected? Choose another document

No problem! You can straightaway pick a different document that better suits what you're after.

Pay as you like, start learning straight away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and smashed it. It really can be that simple.”

Alisha Student

Frequently asked questions