BISI 3230 Class Exercise 1 Instructions

Question # 00802754 Posted By: shortone Updated on: 04/19/2021 08:18 PM Due on: 04/28/2021
Subject Computer Science Topic Algorithms Tutorials:
Question
Dot Image

BISI 3230 – Management Information Systems

Class Exercise 1 Instructions       

  

Design a spreadsheet to compute the expected net income from sales for each quarter and for the whole year using the assumptions below.  Your manager wants to be able to change any of the assumptions and automatically compute the new expected net income.    

 

The sales department has estimated sales unit of 1000 for the first quarter and a 5% increase each succeeding quarter.  The sales department plans to sell the product for $18.95 each. Manufacturing has developed an estimate for the cost of goods sold as $12.45 per unit.  The advertising department has a tentative contract for $1,000.00 per quarter. 

 

The variables (assumptions) to be considered are: first quarter sales, quarterly sales percent increase, selling price (each), cost of goods sold (each), and the quarterly advertising expenses.

 

Notes:  Net income = gross income – advertising expense

            Gross income = revenue – cost of goods sold

            Revenue = unit sales × selling price

 

 

At the end of the class period place a copy of your spreadsheet in the drop box labeled “Excel Project 1” in eLearn.

Dot Image
Tutorials for this Question
  1. Tutorial # 00798433 Posted By: shortone Posted on: 04/19/2021 08:19 PM
    Puchased By: 3
    Tutorial Preview
    The solution of BISI 3230 Class Exercise 1 Instructions...
    Attachments
    ClassExercise1STARTFinal.xlsx (11.13 KB)

Great! We have found the solution of this question!

Whatsapp Lisa