andrew@agcapitalcfo.com

Stage 3 (2023) “Next Gen Gaming”

Professional Excel Templates for your Business

Stage 3 (2023) "Next Gen Gaming"

This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2023, Stage 3 (April 21-24, 2023).

Case study description:

You have made a breakthrough and found what you think will be the next big video game console of the decade! The consoles are straightforward to make and are made up solely of 4 different types of parts, but they are used in different proportions and hence you require a model to make accurate predictions for your production.

You decide to take action to build and launch your product into the market, but you require a financial model to outline your production details, sales, and costs for the next 5 years.

Part 1 – You need to consider the proportions and costs of the parts required to make each console. You must manage the ordering and shipment of parts, the rent for the office space, hiring and salary of workers, marketing expenses, selling price of the consoles, and shipping costs to stores. The challenge is to optimize production and minimize costs while ensuring that all constraints and assumptions are properly accounted for.

Part 2 – You face additional challenges. You need to adjust the part order to avoid excessive inventory at the end of the 5-year period. You must allocate the consoles produced to different stores based on their location, shipping costs, and maximum order capacity. Additionally, you need to plan marketing efforts during the holiday season with a reduced budget.

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data and case assumptions
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

You can also buy tickets to participate in the future FMWC Stages here.

Reviews

There are no reviews yet.

Be the first to review “Stage 3 (2023) “Next Gen Gaming””

Your email address will not be published. Required fields are marked *