Purchase Solution

Excel S2-P3

Not what you're looking for?

Ask Custom Question

1. Complete the invoice using the following information:
a. Key the current date in G6 October 5,2005
b. Each custom costume fee is $2,500.00. Enter this value in F15:F19
c. Total the costume fees in F20
d. A transportation and storage container for each of the five costumes is $75.00.
Enter the appropriate formula in F22 that will calculate the fee for five
Containers.
e. Enter in F23 the delivery for all five costumes as $112.50
f. Enter the formula in F24 that will add the total for the costume fees with the
additional charges.
g. Enter the formula in F25 that will calculate 7% GST (Goods and Services Tax) on the total including additional charges.
h. Enter the formula to total the invoice in F26 as the sum of F24 and F25
i. Forma the worksheet to improve the appearance of the invoice.

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • Electron Configurations

    K+, Cl-, S2-, P3- K+, P3-, S2-, Cl- P3-, S2-, Cl-, K+ Cl-, S2-, P3-, K+ Cl-, S2-, K+, P3- -------------------------------------------------------------------------------- Which element will have the smallest ionization energy?

  • Polynomials : Matrices, Reflection Matrices and Linear Transformation

    35601 Matrices, Reflection Matrices and Linear Transformation From the cubics P3 to the fourth degree polynomials P4, what matrix represents multiplication by 2 + 3t?

  • Accounting: Objective function and equation

    The estimated margin of the products is: P1= 10$, P2= 6$ and P3= 4$ Please evaluate in which quantity the products have to be produced to show the highest margin possible: Material P1 P2 P3 Available Quantity A1 2 1 6 300ea A2 6 5 1 540ea

  • Decision Tree

    of nature are P1 = 0.55, P2 = 0.25, P3 = 0.20 a.

  • Business Research and Statistics

    p3 = 0.30 p3_hat= 80/300 = 0.267 z = (p_hat - p)/sqrt(p*(1-p)/n) z = (0.267 - 0.30)/sqrt(0.3*(1-0.3)/300) = -1.24 Under Ho, p-value = P(Z <= -1.24) == P(Z >= 1.24) = 1 - 0.8925 = 0.1075 == 10.75% (>0.05) Hence, Ho can not be rejected; p3 may

  • Network Optimization Problem

    X P2-C3 , X P3-C1 , X P3-C2 , X P3-C3 are >= 0 Note: If we solve this problem (using Excel-Solver) Cost= $1880 Customers C1 C2 C3 Plants P1 X P1-C1 X P1-C2 X P1-C3 P2 X P2-C1 X P2-C2 X P2-C3 P3 X P3-C1 X P3-C2 X P3-C3

  • Single-Serving Queuing System

    U Please show in excel or word the complete work.

  • Power Cycle for a Piston-Cylinder Device

    V4 = V1 = 0.9 m3 Applying (3) we get : P3(V3)k = P4(V4)k Substituting V4 = 0.9 m3, V3 = 0.4 m3, P3 = P2 = 600 kPa, we get : P4 = P3(V3/V4)k = 600 (0.4/0.9)1.5 = 178 kPa P4 = 178 kPa From (2) P3V3/T3 = P4V4/T4 Or T4 = (P4/P3

  • Problems on Linear programming

    Objective Function: Maximize Z = 15 P1 + 35 P2 + 18 P3 = millions of kilowatt power Constraints: (1) P1 + 2 P2 + P3 <= 30 = tons of Sulfur (2) 3 P1 + 4 P2 + P3 <= 100 = tons of Hydrocarbons (3) 10 P1 + 10 P2 + 6 P3 >= 140 = tons of Superheated Steam

View More Related Solutions