Capsim Forecasting: How many units do we make?

[@JBoling33]

I'm having a hard time understanding figuring out your best case and worst case scenario. Is it just a guess? Or can you give those an educated guess as well? Thanks.

[@74Kurukafa]

Is there a way we can see a screenshot of each of your spreadsheet tabs? (R&D, Forecast, Production, Capacity, Finance, etc...) or perhaps would you be willing to email your template? I'm about to start my project and this would help reduce time spent. Either way, I like what you've done and it certainly helps simplify the process with a user friendly view. Thanks for sharing the video.

[@abhishekkarandikar2395]

How did you come up with the best case and worst case numbers?

[@cryssy54]

Can you please explain how you used the numbers for Fast but you were forecasting for Able?

[@MonicaRoxzify]

Do you have any videos with your excel charts for the finance portion?

[@safaljsingh]

Why did you numbers for fast when you were putting numbers for able

[@heybisperezmartinez1935]

Hi, how can i have a copy of the spreadsheet your are using forecasting products and taking the desicions ?

[@nicolemiller7160]

wait so how did you finally settle on 1000 and 1600 for your best and worst case scenarios ?

[@JBMLKDJJBJ]

Same thing I was asking

[@perilousb0y]

@@JBMLKDJJBJ i think it was an estimate

[@anon-r9q1111]

hes a goofball for not explaining that.

[@Ficall]

Hello, Is there any chance you can share your excel file through a drop box link or Google Drive link?

[@raghad8819]

Where can I find the spreadsheet used here?

[@nicksta2313]

hey i am making this excel sheet but i am trying to figure out for the product count.. is that how many products I have on my team or the amount of products that are currently on the market for all the teams in total?

[@andrew_sar]

Do you have your excel docs?

[@CarolGCStudio]

Saludos, Necesito ayuda para entender cómo saco el peor y el mejor de los casos?

[@jspro6826]

my benchmark is very very low my forcast is double, is that bad?

[@suddate]

great video, Thanks for publishing. Where can I get the spread sheet used in this video?

[@Profgarrett]

HI Sud; You can just copy the rows/columns over -- it's just a simple sheet I put together.

[@Judy874]

Can anyone help? My team got an emergency loan!! Is there a general tip for the next round to lower that loan?!

[@jianadarencrane1269]

Forecast accurately next round. That's the only tip. If you project a positive cash balance, then the only possible way to have an emergency loan is if you overforecast sales (or misforecast strike length).

[@spencer88881]

That was an incredibly helpful video. Thanks!

[@Matahati78]

This video is very well explain! I was wondering if you can show us detailed how to build the excel columns for each decision to calculate and estimate your forecast. Thank you.

[@Profgarrett]

The video walks you through the formula for each column. Just follow along with it as it goes.

[@dianamokoena8704]

@@Profgarrett thank you so much for the video, very helpful. We only get to see the formulas for the Forecasting & production sheets in the video. Are you able to share for the rest?

[@Profgarrett]

@@dianamokoena8704 No, the goal is for students to build the spreadsheet on their own.

[@zachwestra366]

Thanks for the video. Where did you get the spreadsheet?

[@Profgarrett]

Zach Westra I made it myself. It's not too hard to create if you just copy my formatting.

[@zachwestra366]

profgarrett Thank you! Your guides have been extremely helpful in my understanding of this program. I already made my own spreadsheet.

[@elpafe12]

Hi! Anyone help me!!!!I have a question.... If I have a product focused for the traditional market is indispensable that my production and sales will be calculated with the size of both markets? Or I need calculate it only with the value of the traditional segment?

[@Profgarrett]

You need to calculate it for the size of both markets. Even if you are focused on one market, you may still have sales in the other as well. For example, say you are forecasting 1000 units in low-tech. You may still sell another 200-300 units in the high tech market as well. Those are valid sales that you should take advantage of! So, you would produce 1200-1300 additional units to meet demand. Early in the game, the markets align pretty closely, so getting lots of sales in each are easy. But, as the game progresses, you'll find that they get further apart. By the end, the number of units you sell in the "other" market will probably be close to zero.

[@elpafe12]

profgarrett thanks for your help is very useful for me, have a nice day

[@shortdom107]

This makes no sense at all