Homework Answers
In the table below, two if formulas are used. One in calculating the revised re-order level. The formula used is =IF(H4>I4,IF(I4-H4<30,E4,G4),G4). The other formula is used to calculate the Quantity to be ordered. The formula used is =IF(E4<=J4,L4,0). Formulas for row 4 shown.
| Col A | Col B | Col C | Col D | Col E | Col F | Col G | Col H | Col I | Col J | Col K | |
| Rows | Inventory ID | Product Name | Unit price | Quantity in stock | Inventory Value (Unit price * Quantity) | Reorder level | Last purchase price rise information available | Current Date | Revised reorder level | Quantity to order (2 months' consumption to order) | Consumption per month (Units) |
| 4 | 1 | Mechanical item 1 | 5 | 5 | 25 | 5 | 2-Feb-19 | 10-Oct-19 | 5 | 10 | 10 |
| 5 | 2 | Mechanical item 2 | 6 | 10 | 60 | 8 | 20-Oct-19 | 10-Oct-19 | 10 | 12 | 12 |
| 6 | 3 | Electrical item 1 | 7 | 12 | 84 | 15 | 25-Oct-19 | 10-Oct-19 | 12 | 20 | 20 |
| 7 | 4 | Electrical item 2 | 8 | 13 | 104 | 15 | 5-May-19 | 10-Oct-19 | 15 | 25 | 25 |
| 8 | 5 | Lab equipment | 9 | 14 | 126 | 20 | 5-Apr-19 | 10-Oct-19 | 20 | 25 | 25 |
| 9 | |||||||||||
| 10 | 54 | 399 | |||||||||
Add Answer to:
20 points Use your inventory spreadsheet from assignment 1 Add a column (if you don't have...
from your own experience, describe three spreadsheet functions that you have used and found them useful....
from your own experience, describe three spreadsheet functions that you have used and found them useful. In your answers: Describe how each function is designed or formulated Use Excel spreadsheet to provide examples for each function. Show your demonstration in both normal and formula views with row and column headings. Explain why they are useful to you.
Hello guys, i really need your help me solve problem with my assignment excel spreadsheet. how...
Hello guys, i really need your help me solve problem with my
assignment excel spreadsheet. how i put into value in column right
(total : subtotal: HST: Amount Due: ) ? how can i solve problem
like e.g =B2*B3 or =C4+ E4 or ISNUMBER? I am new to excel
spreadsheet, i will learn from you, thank you so much
Problem 2: Invoice Figure 3. You may use the Item, Quantity and List_Price data as provided. • Discount Rate, Discount Threshold...
Part B-25 marks- Inventory management Bike World recently opened several stores in New South Wales. The...
Part B-25 marks- Inventory management Bike World recently opened several stores in New South Wales. The owner is considering whether a perpetual or periodic inventory system should be used. The company also has an inventory of a bike model with details below: Date Item Jun Quantity Unit cost 35 20 35 25 80 35 Inventory 215 217 5 Purchase 7 Purchase 8 Purchase 10 Sale 17 Purchase 20 Sale 25 Purchase 210 208 30 Sale price is $350 per unit...
. Use what you learned from our First Python Program to write a Python program that...
. Use what you learned from our First Python Program to write a Python program that will carry out the following tasks. Ask user provide the following information: unit price (for example: 2.5) quantity (for example: 4) Use the following formula to calculate the revenue: revenue = unit price x quantity Print the result in the following format on the console: The revenue is $___. (for example: The revenue is $10.0.) . . Use the following formula to calculate the...
Assignment C Calculating Components of Operating Statements CREATING AND USING YOUR OWN SPREADSHEET 1. Download and...
Assignment C Calculating Components of Operating Statements CREATING AND USING YOUR OWN SPREADSHEET 1. Download and Open file SPREADSHEET C. 2. Set up formulas in the appropriate cells to calculate the dollar value of gross margin and profit/loss. 3. Now set up formulas in the appropriate cells to calculate percentages for net sales, cost of goods sold, gross margin, operating expenses, and profit/loss. 4. Use this completed spreadsheet to make calculations for the problems that follow. Record your answers on...
All code will be in Java, and there will be TWO source code. I. Write the...
All code will be in Java, and there will be TWO source code. I. Write the class MailOrder to provide the following functions: At this point of the class, since we have not gone through object-oriented programming and method calling in detail yet, the basic requirement in this homework is process-oriented programming with all the code inside method processOrderof this class. Inside method processOrder, we still follow the principles of structured programming. Set up one one-dimensional array for each field: product...
#6 Write a SELECT statement that returns these columns: The count of the number of orders...
#6 Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table Write a SELECT statement that returns one row for each category that has products with these columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table Sort the result set so...
ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 25 points USE EXCEL SPREADSHEET...
ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 25 points USE EXCEL SPREADSHEET FOR ALL OF YOUR WORK #1-Perpetual Inventory Method-Journal Entries-12 points Required: Prepare journal entries for each of the following transactions under the Perpetual Inventory method-include recording date and all required revenue, expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows: Date purchased December 5, 2019 December 20, 2019 December 28,...
Use the Northwind and Hospital data models diagrams to answer the following questions 1.) HOSPITAL: Write...
Use the Northwind and Hospital data models diagrams to
answer the following questions
1.) HOSPITAL: Write a query to list the name and assignment
History for employee #12345. The assigmnet history is to include
the department name and also the number of months the employee
served in that assignment. (Do not worry about the fact that this
cannot be calculated for the current assignment, at least with what
we know now). For one bonus point describe what logic might allow...
Use case diagram for Mail Order System Requirements(draw by use case diagram) This software system is...
Use case diagram for Mail Order System Requirements(draw by use case diagram) This software system is developed to support mail order business operations. In particular software shall: - Keep track of sales (including orders, payments, and shipments). For each order a record shall be kept identifying the customer, the ZIP code, the salesperson, item ordered, the quantity, and amount due. - Record shall be kept for each customer who made a purchase in the past year. Such record shall include...
Hello guys, i really need your help me solve problem with my
assignment excel spreadsheet. how i put into value in column right
(total : subtotal: HST: Amount Due: ) ? how can i solve problem
like e.g =B2*B3 or =C4+ E4 or ISNUMBER? I am new to excel
spreadsheet, i will learn from you, thank you so much
Problem 2: Invoice Figure 3. You may use the Item, Quantity and List_Price data as provided. • Discount Rate, Discount Threshold...
Part B-25 marks- Inventory management Bike World recently opened several stores in New South Wales. The owner is considering whether a perpetual or periodic inventory system should be used. The company also has an inventory of a bike model with details below: Date Item Jun Quantity Unit cost 35 20 35 25 80 35 Inventory 215 217 5 Purchase 7 Purchase 8 Purchase 10 Sale 17 Purchase 20 Sale 25 Purchase 210 208 30 Sale price is $350 per unit...
. Use what you learned from our First Python Program to write a Python program that will carry out the following tasks. Ask user provide the following information: unit price (for example: 2.5) quantity (for example: 4) Use the following formula to calculate the revenue: revenue = unit price x quantity Print the result in the following format on the console: The revenue is $___. (for example: The revenue is $10.0.) . . Use the following formula to calculate the...
Assignment C Calculating Components of Operating Statements CREATING AND USING YOUR OWN SPREADSHEET 1. Download and Open file SPREADSHEET C. 2. Set up formulas in the appropriate cells to calculate the dollar value of gross margin and profit/loss. 3. Now set up formulas in the appropriate cells to calculate percentages for net sales, cost of goods sold, gross margin, operating expenses, and profit/loss. 4. Use this completed spreadsheet to make calculations for the problems that follow. Record your answers on...
ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 25 points USE EXCEL SPREADSHEET FOR ALL OF YOUR WORK #1-Perpetual Inventory Method-Journal Entries-12 points Required: Prepare journal entries for each of the following transactions under the Perpetual Inventory method-include recording date and all required revenue, expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows: Date purchased December 5, 2019 December 20, 2019 December 28,...
Use the Northwind and Hospital data models diagrams to
answer the following questions
1.) HOSPITAL: Write a query to list the name and assignment
History for employee #12345. The assigmnet history is to include
the department name and also the number of months the employee
served in that assignment. (Do not worry about the fact that this
cannot be calculated for the current assignment, at least with what
we know now). For one bonus point describe what logic might allow...
Most questions answered within 3 hours.
-
(63
#14)
which of the following statments best describes how chamging
the concentration of the substances...
asked 1 hour ago -
In the following reaction, which element is undergoing
oxidation: Na2SO3 + N2O --> N2 + Na2SO4...
asked 2 hours ago -
Which of the following pairs of ions have the same electron
configuration?
I: Br− and Se2−...
asked 4 hours ago -
The Foremost Composite Materials Company is planning a two-day
sales conference for October 19-20. The conference...
asked 5 hours ago -
3) Illustrate the observed pattern of relatedness of organisms
versus adaptations to specific conditions. This means...
asked 5 hours ago -
In winter a lake has a 0.35 m thick ice layer over 1.10 m of
water....
asked 6 hours ago -
Assuming the following has been encrypted with a Vigenere cipher
below, use the method(s) and assumptions...
asked 6 hours ago -
How would I use switch statements to write a program that will
take an input of...
asked 6 hours ago -
Imagine a reaction in which methane gas combusts at a constant
pressure of 1 atm and...
asked 6 hours ago -
Two parallel wires (each 12 m in length) are separated by a
distance of 0.065 m...
asked 6 hours ago -
Suppose there were three masses at the corner of uniform
equilateral triangle. The masses are m1...
asked 6 hours ago -
Situation: A building that is 618 m above the ground floor. How
many times would a...
asked 7 hours ago