Suppose a small business has sales of $14,000 this month, with future sales expected to grow by $1,000 each month. Costs consist of a fixed component, which is $8,400 per month, and a variable component, which is 25 percent of sales. Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period. What is the gross profit in a single month 5 months from now?

Suppose a small business has sales of $14,000 this month, with future sales expected to grow by $1,000 each month. Costs consist of a fixed component, which is $8,400 per month, and a variable component, which is 25 percent of sales. Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period. What is the gross profit in a single month 5 months from now?

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Similar questions

A company has several employees, all with different names, who perform interviews with job applicants (one applicant is interviewed by one employee). The job applicants also have different names. The interviewer makes appointments for interviews with the applicants. Each applicant may be interviewed at several occasions, possibly by different interviewers, but in that case the interviews take place during different days. The company has special interview rooms. Each interviewer uses the same room for all interviews during a day. A room may, however, be used by different interviewers during a day, as long as the interviews don't collide in time. The reservation of interview appointments is to be computerized. The database devel- oper has decided to use a single relation for all data, with the following schema: Interviews(interviewer, applicant, day, time, room) a) From the text, find functional dependencies in the relation. b) Find the keys of the relation. c) Show that the relation is…
Develop a VBA function to take the square root of the sum of the squares of two numbers. Using A= 6, B= 8 ****USE THIS FUNCTION ON CELL A1 IN THE SPREADSHEET.*** USING FUNCTION****
The worksheet shown in the figure below contains two years of sales that will be used to create a PivotChart. The goal is to create a column chart that shows the total sales dollars by year for each month. Given this goal, what would be the best chart area to place the Year field? 1 2 3 4 3 6 7 . 9 10 11 12 13 14 15 Year Month 2017 April 2018 April 2017 August 2018 August 2017 December 2018 December 2017 February 2018 February 2017 January 2018 January 2017 July 2018 July 2017 June 2018 June VALUES O LEGEND AXIS FILTERS Total Sales Dollars $ 50,970.00 $ 48,400.00 $ 52,470.00 $ 50,700.00 $112,425.00 $120,000.00 $ 56,205.00 $ 56,850.00 $ 59,940,00 $ 62,950.00 $19.980.00 $ 18,500.00 $ 22.485.00 $ 21,000.00
Use the following classes to draw a basic POS System Class Diagram. Customer Vendor Products Pricelist Transactions
Suppose you are organizing a conference where researchers present articles they have written. Researchers who want to present an article send a paper to the conference organizers. The conference organizers have access to a committee of reviewers who are each willing to read up articles each. Each paper submission gets reviewed by up to reviewers. Moreover, each submission has a particular topic and each reviewer has a specialization for a set of topics, so papers on a given topic only get reviewed by those reviewers who are experts on that topic. The conference organizers need to decide which reviewers will review each article (or equivalently, which articles will be reviewed by which reviewers). Explain how they could use a flow network to solve this problem.
A warehouse is where the company stores its products and the storage bins in the warehouse are specified identified to their aisle, location in the aisle, and its shelf. There are a total of 40 aisles, 64 horizontal locations in each aisle, and 6 shelves. What is the least number of products the company can have so that at least two products must be stored in the same bin?
For this system Write scenario for add a book for the list (For Employee) →and design the corresponding Sequence Diagram (as you learned in the LAB) System Main Functions For Student - Login -Reserve a place Library of university system - Borrow a book - Order a book - Return a book - Add book For Employee - Login - Add a book for the list - Remove a book from the list - Edit book information - Writing a daily report (for users and books) Example in Lab Cashier Cash Reg Sale Product Hem sd Buy a Produxt Cash Register Syzem Product hem Casiier 1: add new sale 1.1: create a sale Sale loop 2: check in pro dud Check in al products 3: get produd details (description, price) 4 add product 5 calculate total 6: etum total 7: process payment (amount) 7.1: verity aniount
Predictive modeling: Task: Ambulance Demand Data Generating Process: Using the service data: The data is collected by the " NYC Traffic data” to answer the questions: Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?} Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police} Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?} Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.} Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.} Data Collector{Who collects the data? A dispatcher? A Census taker?} Triggering Process{What triggers the data to be collected?…
Suppose you are an astrologer and you are predicting the zodiac sign of the customer using month and date of the birth given by the user. Conditions to predict the zodiac sign are given in the following table: Zodiac Sign From - To December 22 - January 19 January 20 - February 17 February 18 - March 19 March 20 - April 19 Capricorn Aquarius Pisces Aries April 20 - May 20 May 21 - June 20 June 21- July 22 July 23 - August 22 August 23 - September 22 September 23 - October 22 October 23 - November 21 Taurus Gemini Cancer Leo Virgo Libra Scorpio Sagittarius November 22 - December 21 Write a C program for the above scenario using if statement.
A circus is putting on a tower show in which individuals perch on top of each other's heads. Each individual must be both shorter and lighter than the person below him or her for functional and aesthetic purposes. Create a method to determine the greatest number of people who can fit in such a structure based on the heights and weights of each circus member.
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
Using VBA for Excel, write a program which iterates the secant method for a function at two values until the residual is less than the user-defined threshold. Outputs are: final value and residual