Question

Wk Qu. 4-13 A student prepared the following.. A student prepared the following spreadsheet model to calculate the final pric

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Determination of value of Service tax and Final price:

A B (Value)
4 Discount in dollars ($) (180×0.2) 36
5 Net price ($) (180-36) 144
7 Service tax in dollars ($) (144×0.09) 12.96
8 Final price ($) (144+12.96) 156.96

Service tax is $ 12.96

Final price is $ 156.96

Add a comment
Know the answer?
Add Answer to:
Wk Qu. 4-13 A student prepared the following.. A student prepared the following spreadsheet model to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Wk Qu. 4-11 In the spreadsheet model... In the spreadsheet model shown below, an analyst makes...

    Wk Qu. 4-11 In the spreadsheet model... In the spreadsheet model shown below, an analyst makes the following data entries. Cell Value B3 88,000 B4 86,000 B5 83,000 B6 L 95,000 Revenue 2 Month 3 January 4 February 5 March 6 April Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5/B5 What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Value Cell C4 |

  • Wk Qu. 4-12 An analyst built the following... An analyst built the following spreadsheet, complete with...

    Wk Qu. 4-12 An analyst built the following... An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). TA 1 2 Unit Price 3 Unit Cost 4 Unit Gross Profit 10 5.73 Unit Price - Unit_Cost Quantity Sold 7,500 6 7 8 9 10 11 12 ost Gross Revenue Variable Costs Fixed Costs Net Profit Profit per Unit = Quantity_Sold x Unit Price = Quantity_Sold x...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 42,000 Accounts receivable 364,000 Raw materials inventory 107,200 Finished goods inventory 349,440 Total current assets 862,640 Equipment 604,000 Accumulated depreciation (152,000 ) Equipment, net 452,000 Total assets $ 1,314,640 Liabilities and Equity Accounts payable $ 211,300 Short-term notes payable 14,000 Total current liabilities 225,300 Long-term note payable 510,000 Total liabilities 735,300 Common stock 337,000 Retained...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Accounts receivable Ravw materials inventory Finished goods inventory Total cument assets 438.750 Accumulated depreciation 158,000 Total assets Liabilities and Equity Short-tem notes pay able Total current liabilities Long-tem note payable Total stockholders' equity Total liabilities and equity To prepare a master budget for April, May, and June of 2017, management gathers the following information: a. Sales for...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash 58,000 484,640 91,290 Accounts receivable Raw materials inventory Finished goods inventory 393,304 Total current assets 1,027,234 Equipment, gross Accumulated depreciation Equipment, net 636,000 168,000) 468,000 $1,495,234 Total assets Liabilities and Equity Accounts payable Short-term notes payable 206,390 30,000 Total current liabilities 236,390 Long-term note payable Total liabilities 525,000 761,390 Common stock 353,000 Retained earnings 380,844 Total...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity 65,000 437,760 90, 200 308, 028 900,988 630,000 (165,000) 465,000 $...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019 ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets 43,ee0 432,900 Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets 86,198 387,168 949,266 606,000 (153,000) 453,000 Equipment Accumulated depreciation Equipment, net Total assets $1,402,266 Liabilities and Equity 194,798 15,000 Accounts payable Short-term notes payable 209,798 s00,e00 Total current liabilities Long-term note payable Total liabilities 709,798 Common stock 338, еее 354,468 692,468 Retained earnings...

  • I need help on part 9 & 10 and 8 The management of Zigby Manufacturing prepared the following estimated balance...

    I need help on part 9 & 10 and 8 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets $ 65,000 437,760 90,200 Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets 308,028 900,988 630,000 165,00 Equipment, gross Accumulated depreciation Equipment, net 465,000 1,365,988 Total assets Liabilities and Equity $ 204, 500 Accounts payable Short-term notes payable Total current liabilities 27,000 231,500 Long-term...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 44,000 500,000 90,200 444,000 1,078, 200 608,000 (154,000) 454,000 $1,532,200...

  • The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING...

    The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2817 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets $44,888 58e,8e 98,288 444,888 1,878,288 688,888 154,888) 454,88e $ 1,532,288 Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT