Identified the various factors

Assignment Help Basic Statistics
Reference no: EM133266339

You are in charge of a young and growing company. You have identified the various factors (sources of revenue and expenses) that influence the company business as shown below.

All the figures are in thousands of Kenya Shillings except the percentages.

ANNUAL INCOME AND EXPENSES PROJECTION

 

Revenue

 

Sales

Starts at 10,000 and grows by 8%

Expenses

 

Raw materials

15% of sales

Transport

7% of sales

Electricity

2.1% of sales + 10

Rent

Starts at 120 then grows by 2%

Salaries

Starts at 1,000 then grows by 10%

Commissions (Sales)

1.8% of sales

Loan repayment

170

Advertising and promotion

2.5% of sales

Depreciation

Fixed at 20

Miscellaneous

Starts at 10 and grows by a fixed amount of 10

Total (Expenses)

 

Profit

 

  1. Use the information provided in the table above to produce a financial projection model for the company for the next six years.
  2. Make a line graph of sales, total expenses and profit for the six-year period.      
  3. Find the average expenses, sales and profit for the six-year period.        
  4. Print the worksheet and the graph

Reference no: EM133266339

Questions Cloud

What is the most economical order quantity : A manufacturing company places a semi-annual order of 24,000 units at a price of $20 per unit. Its carrying cost is 15% and the order cost is $12 per order.
Service company to achieve global success : The first to set up an international air express business in 1969, DHL had the first-mover advantage over other companies. Is being a first mover as advantageou
Describe what primary health care is : Describe what primary health care is and how you understand the role of the nurse practitioner in primary health care
Explain the profit maximization problem : In the formal presentation of the Newsvendor problem, we have shown that the profit maximization problem is equivalent to the minimizing of the following cost f
Identified the various factors : You are in charge of a young and growing company. You have identified the various factors (sources of revenue and expenses) that influence the company business
Dickey-fuller and the augumented dickey-fuller : Describe in detail the Dickey-Fuller and the augumented Dickey-Fuller (ADF) procedure for testing for the order of integration of a time series variable.
What should she score in the final exam : Tina is getting ready to take the final exam for MAT 143. Her averages before the final exam are given. Test average= 68; Hand in assignment average = 75; MML a
What should she score in the final exam : Tina is getting ready to take the final exam for MAT 143. Her averages before the final exam are given. Test average= 68; Hand in assignment average = 75; MML a
How does walmart go green without going into red : How does Walmart go green without going into red (low)? Who are the stakeholder groups Walmart is serving in its renewal energy business

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd