Please create an product pricing and computation. The picture is the financial plan copy.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%
Please create an product pricing and computation. The picture is the financial plan copy.
IN PHILIPPINE PESO
QUANTITY
ITEMS
COST
TOTAL
32
Computer Chair
P4,375.00
P140,000.00
Conference Table
P7,420.00
P7,420.00
2
Center Table
P4,130.00
P8,260.00
Office Desk
P23,940.00
P23,940.00
Sofa
P25,200.00
P25,200.00
3.
Hanging Cabinet
P4,900.00
P14,700.00
Locker
P9,660.00
P9,660.00
7
Filing Cabinet
P7,980.00
P55,860.00
5
Drawer
P7,910.00
P39,550.00
Trash Can
Mini Chandelier
10
P152.00
PI,520.00
PI,645.00
P1,645.00
10
Hallway Ceiling Lights
P311.00
Р3, П0.00
Service Counter
P40,000.00
P200,000.00
Dining Set
P9,380.00
P9,380.00
Whiteboard
P9,306.00
P9,306.00
10
All-in-one desktop
P28,902.37
P289,023.70
Digital TV
Digital TV
Laptop
P20,990.00
P20,990.00
4
P15,499.00
P61,996.00
12
P26,010.00
P312,120.00
P2,995.00
P13,700.00
Wi-Fi Router
P17,970.00
All-in-one- inkject printer
P13,700.00
Telephone
Projector
P621.00
P3,726.00
P25,300.00
P25,300.00
Projector Presentation Screen
P1,620.00
P1,620.00
3
Air Conditioner
P55,999.00
P167,997.00
Coffee Maker
P2,172.00
P2,172.00
1
Refrigerator
P10,498.00
P10,498.00
Microwave Oven
P3,598.00
P3,598.00
Water Dispenser
P2,199.00
P2,199.00
Office Supplies
P6,000.00
P6,000.00
14
Calculator
P710.00
P9 940.00
4
Toilet Bowl
P5,200.00
P20,800.00
4
Sink
P2,280.00
P9,120.00
4
Mirror
P690.00
P2,760.00
Spray Bidet
P400.00
P1,600.00
6
First Aid Kit
P350.00
P2, 100.00
Fire Extinguisher
Тагрaulin
Tarpaulin Stand
PI,100.00
P2,200.00
4
P1,000.00
P4,000.00
4
P449.00
PI,796.00
8
Bar Stool
PI,800.00
P14,400.00
4
Canopy tent
PI.800.00
P7,200.00
ТОTAL
PI,564,376.70
--•---|---|-|-|-
Transcribed Image Text:IN PHILIPPINE PESO QUANTITY ITEMS COST TOTAL 32 Computer Chair P4,375.00 P140,000.00 Conference Table P7,420.00 P7,420.00 2 Center Table P4,130.00 P8,260.00 Office Desk P23,940.00 P23,940.00 Sofa P25,200.00 P25,200.00 3. Hanging Cabinet P4,900.00 P14,700.00 Locker P9,660.00 P9,660.00 7 Filing Cabinet P7,980.00 P55,860.00 5 Drawer P7,910.00 P39,550.00 Trash Can Mini Chandelier 10 P152.00 PI,520.00 PI,645.00 P1,645.00 10 Hallway Ceiling Lights P311.00 Р3, П0.00 Service Counter P40,000.00 P200,000.00 Dining Set P9,380.00 P9,380.00 Whiteboard P9,306.00 P9,306.00 10 All-in-one desktop P28,902.37 P289,023.70 Digital TV Digital TV Laptop P20,990.00 P20,990.00 4 P15,499.00 P61,996.00 12 P26,010.00 P312,120.00 P2,995.00 P13,700.00 Wi-Fi Router P17,970.00 All-in-one- inkject printer P13,700.00 Telephone Projector P621.00 P3,726.00 P25,300.00 P25,300.00 Projector Presentation Screen P1,620.00 P1,620.00 3 Air Conditioner P55,999.00 P167,997.00 Coffee Maker P2,172.00 P2,172.00 1 Refrigerator P10,498.00 P10,498.00 Microwave Oven P3,598.00 P3,598.00 Water Dispenser P2,199.00 P2,199.00 Office Supplies P6,000.00 P6,000.00 14 Calculator P710.00 P9 940.00 4 Toilet Bowl P5,200.00 P20,800.00 4 Sink P2,280.00 P9,120.00 4 Mirror P690.00 P2,760.00 Spray Bidet P400.00 P1,600.00 6 First Aid Kit P350.00 P2, 100.00 Fire Extinguisher Тагрaulin Tarpaulin Stand PI,100.00 P2,200.00 4 P1,000.00 P4,000.00 4 P449.00 PI,796.00 8 Bar Stool PI,800.00 P14,400.00 4 Canopy tent PI.800.00 P7,200.00 ТОTAL PI,564,376.70 --•---|---|-|-|-
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Pricing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.