Input no. of shirts Price per shirt Total Charges Discount Net Fee Free-shirts Sample Output 1: Input no. of shirts Price per shirt Total Charges Discount Net Fee Free-shirts Sample Output 2: Input no. of shirts Price per shirt Total Charges Discount Net Fee Free-shirts Sample Output 3: Input no. of shirts 53 20 Php230.00 Php4,600.00 Php4,600.00 2 53 Php200.00 Php10,600.00 Php0.00 With discount 53 Provide your formula on the blue blank cells. The specification of the formula can be read from the comments in each cell. The white cells are user input Php10,600.00 5 With discount Php0.00 With discount 10

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter16: Manufacturing Accounting (mfg)
Section: Chapter Questions
Problem 2R
icon
Related questions
Question
Input no. of shirts
Price per shirt
Total Charges
Discount
Net Fee
Free shirts
Sample Output 1:
Input no. of shirts
Price per shirt
Total Charges
Discount
Net Fee
Free shirts
Sample Output 2:
Input no. of shirts
Price per shirt
Total Charges
Discount
Net Fee
Free shirts
Sample Output 3:
Input no. of shirts
53
20
Php230.00
Php4,600.00
Php4,600.00
2
53
Php200.00
Php10,600.00
Php0.00 With discount
53
Provide your formula on the blue blank
cells. The specification of the formula can
be read from the comments in each cell.
The white cells are user input
Php10,600.00
5
With discount
Php0.00 With discount
10
Transcribed Image Text:Input no. of shirts Price per shirt Total Charges Discount Net Fee Free shirts Sample Output 1: Input no. of shirts Price per shirt Total Charges Discount Net Fee Free shirts Sample Output 2: Input no. of shirts Price per shirt Total Charges Discount Net Fee Free shirts Sample Output 3: Input no. of shirts 53 20 Php230.00 Php4,600.00 Php4,600.00 2 53 Php200.00 Php10,600.00 Php0.00 With discount 53 Provide your formula on the blue blank cells. The specification of the formula can be read from the comments in each cell. The white cells are user input Php10,600.00 5 With discount Php0.00 With discount 10
Price per shirt
Total Charges
Discount
Net Fee
Free shirts
Sample Output 4:
Input no. of shirts
Price per shirt
Total Charges
Discount
Net Fee
Free shirts
Php200.00
Php10,600.00
Php1,060.00 With discount
Php9,540.00
5
9
Php230.00
Php2,070.00
Php207.00 With discount
Php1,863.00
0
1
1
Transcribed Image Text:Price per shirt Total Charges Discount Net Fee Free shirts Sample Output 4: Input no. of shirts Price per shirt Total Charges Discount Net Fee Free shirts Php200.00 Php10,600.00 Php1,060.00 With discount Php9,540.00 5 9 Php230.00 Php2,070.00 Php207.00 With discount Php1,863.00 0 1 1
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Accounting Information Systems
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning