Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Previously searched by you
Previously searched by you
logo
  • Hanzehogeschool Groningen (Hanze)
  • SIM1 TopSim (SIM1)
To add items to your wishlist, you must be logged in
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
Hanzehogeschool Groningen (Hanze)
Course
SIM1 TopSim (SIM1)

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
Report Copyright Violation

Written for

Institution
Hanzehogeschool Groningen (Hanze)
Study
International Business and Management Studies
Course
SIM1 TopSim (SIM1)
All documents for this subject (1)

Document information

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

Subjects

  • number of sales employees
  • qualification index
  • decisions
  • sales price
  • quantity
  • number of machines
  • sales planning
  • production planning
  • topsim
  • financial repors
$31.09
Get access to the full document:
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Get to know the seller
Seller avatar
xsaturn5x

Get to know the seller

Seller avatar
xsaturn5x Hanzehogeschool Groningen
View profile
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
4 year ago

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Recently viewed by you

Thumbnail
Presentation
meditation
-
2023
$ 18.49 More info
Thumbnail
Package deal
Bundel biodiversiteit dier
-
1 2021
$ 10.75 More info
Thumbnail
Class notes
Introduction to cutting tool
-
2023
$ 8.49 More info
Thumbnail
Summary
Samenvatting Onderneming en overheid
-
2025
$ 9.52 More info

Why students choose Stuvia

Created by fellow students, verified by reviews

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

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right 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 aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Learn more Create citation
Working on your references?

Frequently asked questions