🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: can.schoolnet.problems
Article #173

Problem

#173
From: mark
Date: Sun, 21 Jan 1996 00:00
16 lines
1134 bytes
I'm doing a project and I need to design a model to simulate the effect
hte selling price of an item has on the overall profit a company makes.
I'm doing it in a spreadsheet and the columns are as follows:
Col. A = Cost Price(Per Item) ;  Col. B = No. Bought ;  Col. C = No. Sold
;  Col. D = Selling Price ; 
Col. E = Overall Profit.
Therefore I need two formulae, the first to work out the no. sold, when
the figures in columns A, B and D vary (increasing in set increments) and
the second to work out the overall profit.
Can someone please work out a formula and email it to me (do not post,
please) at 
mark@mewi.demon.co.uk as soon as possible.
Express the formula in terms of A,B,C,D and E (as in the columns- e.g. -
B*2 would equal 
No. Bought multiplied by two).
Thanks.
Technical Details
Message-ID: <mark-2101962030170001@mewi.demon.co.uk>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fce00,239250d39a738159,start
X-Google-Attributes: gidfce00,public
From: mark@mewi.demon.uk
Subject: Problem
Date: 1996/01/21
Message-ID: <mark-2101962030170001@mewi.demon.co.uk>
X-Deja-AN: 136629277
x-nntp-posting-host: mewi.demon.co.uk
newsgroups: can.schoolnet.problems