Delta warehouse has hundreds of items in their warehouse, and here are 10 major items named A, B, C to J accordingly.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Delta warehouse has hundreds of items in their warehouse, and here are 10 major items named A, B, C to J accordingly.

The opening inventory quantity is 12,323; 13,444; 11,220; 8,900; 9,720; 11,343; 9,763; 6,780; 99,740; 12,320, respectively. Prices are $4.99; $6.99; $7.99; $9.99; $10.59; $50.99; $8.99; $24.59; $32.99; $65.59, respectively. Here are their customer orders. 1. Flora company ordered 80 A item, 60 G item

2. Smith company ordered 722 B item, 360 D item, 230 H item, 480 J item 3. Joanna company ordered 340 C item, 248 E item, 68 F item, 230 I item, 50 J item 4. Shaw company ordered 110 B item, 200 D item, 80 E item. 5. Hannah company ordered 224 A item, 340 C item, 200 H item, 120 J item Calculate the following using functions and formulas.

• Total assets

• Total sales

• Value of total sales

• Remaining inventory

• Value of remaining inventory

• Highlight 3 best selling items • Create a Bar chart to show the value of total sales • Create a PivotTable & Pivot Chart to show remaining inventory

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme