At the office, Janny keeps some office supplies to make sure she always has enough supplies for the office. Please see the information below and develop the proper spreadsheet module for the company if you get a quantity discount.

parameters

parameters

office supllies

Price per unit

Up to order point

Inventory$-$on$-$hand

Order Quantity discount

discount rate

cost of order each time

$\backslash$table$[[$Calculator$,,$Pen $($box$),$Pencil $($box$),$Eraser$],[$$$,35\mathrm{.}00,10\mathrm{.}00,25\mathrm{.}00,2\mathrm{.}00],[,10\mathrm{.}00,15\mathrm{.}00,13\mathrm{.}00,6\mathrm{.}00],[,2\mathrm{.}00,1\mathrm{.}00,0\mathrm{.}00,3\mathrm{.}00]]$

Moudel

office supllies

order quantity

cost of goods

Number of orders

Total cost of order

Total cost of goods

Total cost of purchasing supplies

$\backslash$table$[[85\%$