Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

looking for how to put in SPSS Assignment 8.1- Problem Set 3 Complete the following problems. 1. Develop a simulation model in SPSS for a

image text in transcribed
looking for how to put in SPSS
Assignment 8.1- Problem Set 3 Complete the following problems. 1. Develop a simulation model in SPSS for a three-year financial analysis of total profit based on the following data and information. Sales volume in the first year is 100,000 units and is projected to grow at a rate that is normally distributed with a mean of 7% per year and a standard deviation of 4%. The selling price is $10 and the price increase each year is normally distributed with a mean of $0.50 and a standard deviation of $0.05 each year. Per-unit variable costs are $3, and annual fixed costs are $200,000. Per-unit variable costs are expected to increase by an amount normally distributed with a mean of 5% per a year and a standard deviation of 2%. Fixed costs are expected to increase following a normal distribution with a mean of 10% per year and a standard deviation of 3%. Report the descriptive statistics for profit each year and the cumulative profit. How confident are you that profits will increase each year? Use the percentiles report to answer this question and provide appropriate evidence. (NOTE: Sales, prices, and costs are NOT uncertain but rather the growth in each of these is uncertain. You should get a new growth value each year for each of the four variables for a total of eight uncertain items.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit And Assurance Q And A 2019

Authors: ACA Simplified

1st Edition

1792949863, 978-1792949869

More Books

Students also viewed these Accounting questions

Question

Types of Interpersonal Relationships?

Answered: 1 week ago

Question

Self-Disclosure and Interpersonal Relationships?

Answered: 1 week ago