Please help me answer C and D. If you know how to properly enter the formulas into Excel, that would be super helpful as well! 1 2 Determine the missing amounts in each of these four separate situations a through d. 3 4 5 6 Supplies available-prior year-end 7 Supplies purchased during current year 8 Total supplies available 9 Supplies available-current year-end 10 Supplies expense for current year 11 12 b $1,840 5,890 7,730 a $1,050 3,150 4,200 (1,500) (2,700) $5,030 C $1,600 6,400 (2,200) $4,200 d 8,220 10,960 (3,800) $7,160

Please help me answer C and D. If you know how to properly enter the formulas into Excel, that would be super helpful as well! 1 2 Determine the missing amounts in each of these four separate situations a through d. 3 4 5 6 Supplies available-prior year-end 7 Supplies purchased during current year 8 Total supplies available 9 Supplies available-current year-end 10 Supplies expense for current year 11 12 b $1,840 5,890 7,730 a $1,050 3,150 4,200 (1,500) (2,700) $5,030 C $1,600 6,400 (2,200) $4,200 d 8,220 10,960 (3,800) $7,160

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

este X * CengageNOww2 | Online teachin x : Cengage Learning genow.com.filrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=8inprogress=false еВook Show Me How Providing for Doubtful Accounts At the end of the current year, the accounts receivable account has a debit balance of $969,000 and sales for the year total $10,990,000. a. The allowance account before adjustment has a credit balance of $13,100. Bad debt expense is estimated at 1/4 of 1% of sales. b. The allowance account before adjustment has a credit balance of $13,100. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $41,900. C. The allowance account before adjustment has a debit balance of $4,600. Bad debt expense is estimated at 3/4 of 1% of sales. d. The allowance account before adjustment has a debit balance of $4,600. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $38,200. Determine the amount of the adjusting…
O Mail - Edjouline X E Content - ACG2 X * CengageNOW. X O (58) YouTube * from Towards a X m/ilm/takeAssignment/takeAssignmentMain.do?invoker=assignments&takeAssignmentSessionLocator=assignment-take&inpro. Q < ☆ STIOW Me TOW Percent of Sales Method At the end of the current year, Accounts Receivable has a balance of $410,000; Allowance for Doubtful Accounts has a credit balance of $3,500; and sales for the year total $1,850,000. Bad debt expense is estimated at 3/4 of 1% of sales. a. Determine the amount of the adjusting entry for uncollectible accounts. b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense. Adjusted Balance Debit (Credit) Accounts Receivable Allowance for Doubtful Accounts Bad Debt Expense c. Determine the net realizable value of accounts receivable. Check My Work Previous Next V O 11:51
10:04 Assignment Details ATG-110-20A01: Financial Accounting (Session II Summer 2021) 7474 unread replies.7575 replies. Please read and respond to TIF 12-2 on page 623. Review the rubric to ensure you receive full points for this discussion. Discussion Rubric- 25 points(1)_(3).docx *After you have posted your answers, please reply to three other students' posts. This discussion board was set up so that you will not be able to see others replies until you post your own. Search entries or author Filter replies by unreadUnread Collapse replies TIF 12-2 Issuing Stock 1. ETHICS Lou Hoskins and Shirley Crothers are organizing Red Lodge Metals Unlimited Inc. to undertake a high-risk gold mining venture in Canada. Lou and Shirley tentatively plan to request authorization for 400,000,000 shares of common stock to be sold to the general public. Lou and Shirley have decided to establish par of $0.03 per share in order to appeal to a wide variety of potential investors. Lou and Shirley believe…
Class Collaborate-AC-163-44 P x CengageNOWv2| Online teachin X + 2.cengagenow.com/ilmn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignments... A Determine the following measures for 2018. Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume there are 365 days in the year. 1. Working capital Г 2,790,000 2. Current ratio 4.1 3. Quick ratio 2.5 4. Accounts receivable turnover 16 5. Days' sales in receivables 22.8 days 6. Inventory turnover 7. Days sales in inventory 8. Debt ratio days % 9. Ratio of liabilities to stockholders' equity 10. Ratio of fixed assets to long-term liabilities 11. Times interest earned times times 12. Times preferred dividends earned Check My Work 8 144 0 P Previous Email Instructor Save and Exr Submit Assignment for Grading pri se…
Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.
Test2 Intermediate Accounting - Word (Product Activation Failed) NSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Times New Ro - -A A Aa - AaBbCcl AaBt AaBbC AaBbCel AaBbCcl AaBbCc) AaBbCc IU-abe x, x A - *- A- ====- Emphasis THeading 1 THeading 3 THeading 6 1 Normal Strong Subtitle Font Paragraph December 31 Styles Assets 2010 2009 Cash Accounts receivable $73,000 85,000 170,000 75,000 260,000 (66,000) $ 22,000 76,000 189,000 100,000 200,000 (32,000) Inventories Land Equipment Accumulated depreciation Total $597,000 $555,000 Liabilities and Stockholders' Equity $ 39,000 Accounts payable Bonds payable Common stock ($1 par) Retained earnings $ 47,000 150,000 216,000 192,000 $597,000 200,000 174,000 134,000 $555,000 Total Additional information: 1. Net income for 2010 was $103,000. 2. Cash dividends of $45,000 were declared and paid 3. Bonds payable amounting to $50,000 were redeemed for cash $50,000. 4. Common stock was issued for $42,000 cash. 5. No equipment was sold during…
Brown): Week 3 CU122-0 2201 (Brown): Week 4 x Week 6: Culmination Knowledge x + empt.php?attempt=2921412&cmid%=866335 A fr. Enduring Word Bibl. b My Questions | bart. Financial Aid Student Accounts Resources Campus Store c. $8,550 d. $9,280 Chef Fabio does beginning inventory on Thursday night and finds that he has $1456 in food products in the restaurant. Throughout the week he purchases: • $457 produce, • $632 protein, • $356 dry goods, and • $147 dairy. The following Thursday he does ending inventory and finds that he has $1643 in food. He looks at his sales and finds that he made $5546 over the same 7 day period. What is his food cost as a percentage of sales (food cost percentage)? Select one: a. 54.96% b. 28.70% c. 55.88% d. 25.33% The ingredients for your braised greens cost $1.32. You sell it for $4. What is your contribution margin? nswered Select one: ut of 1.00 a. $3.18 question F2
Digital Learning * CengageNOwv2 | Online teachir * Cengage Learning + Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false A eBook Show Me How Percent of Sales Method At the end of the current year, Accounts Receivable has a balance of $555,000; Allowance for Doubtful Accounts has a credit balance of $5,000; and sales for the year total $2,500,000. Bad debt expense is estimated at 1/4 of 1% of sales. a. Determine the amount of the adjusting entry for uncollectible accounts. b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense. Accounts Receivable 24 Allowance for Doubtful Accounts Bad Debt Expense %24 c. Determine the net realizable value of accounts receivable. Feedback Check My Work a. Remember that since accounts receivable are created by credit sales, uncollectible accounts çan be estimated as a percent of credit sales. If the portion of credit sales to sales id relatively constant, the…
dex.html?_con-contexternal browser-08launchUrd-http%253A% User Management,.. https://outlook.off.. 2Haytechccblackboard.com%252 FES Protection Plan work Exercises Seved 2. On June 1, 20X1, the firm bought supplies for $7,750. The $7750 was debited to the Supplies account. An inventory of supplies at the end of June showed that items costing $3,200 were on hand. 3. On June 1, 20X1, the firm bought equipment costing $67,200. The equipment has an expected useful life of 10 years and no salvage value. The firm will use the straight-line method of depreciation. Prepare end-of-June adjusting entries for Conner Company View transaction list Journal entry worksheet A B Prepare the adjusting entry for prepaid rent. Note: Enter debits before credits. Debit Credit Transaction General Journal 1 Next >
含 m Ne document/d/11qn3JrhFphZqFZrCf7vTe1m5k6CzPzQTI7VGITIH7Lg/edit Checking Register Practice D ☺ Tools Add-ons Help Last edit was 4 hours ago al text Arial BIUA c田回,三三三三三 11 + 1 5. Enter the following transactions for the Month of September. You have a beginning balance of $1500.00 $456.23 September 2 September 4 September 7 September 11 Deposit Check #123 Rick's Running Shop -- Shoes Check #124 Jacob' Jamboree -- New Outfit Check # 125 JCP Department Store - Furniture $94.67 $45.23 $398.99 ATM Withdrawal (($2.00 Service Fee) Check # 126 High Point Clothing Store – Pet Clothes $50.00 $124.76 $498.75 September 13 September 14 September 16 September 21 September 25 September 27 Deposit Check # 127 Abigail's Archery Shop -- Arrows $185.99 Check # 128 Denise's Dance Studio -- Dance Lessons $203.77 Check #129 Michael's Pet Store -- Dog Food $49.99 September 30 Deposit 501.33 Payment / Debit Number or Deposit / Code Date Transaction Description Fee Credit Balance Beginning Balance 237.47…
Font Paragraph Styles 4. Purchased Supplies for RO 150 and paid RO 100. Remaining amount will be paid after one month
-et: Mod x * CengageNOWv2 | On x * Cengage Learning B Milestone Two Guidel x G module 5 problem set x om/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=. O eBook Show Me How Journalizing Installment Notes On the first day of the fiscal year, a company issues $52,000, 11%, five-year installment notes that have annual payments of $14,070. The first note payment consists of $5,720 of interest and $8,350 of principal repayment. a. Journalize the entry to record the issuance of the installment notes. If an amount box does not require an entry, leave it blank. b. Journalize the first annual note payment. If an amount box does not require an entry, leave it blank. Previous Next Check My Work. 3:34 P 56°F Mostly cloudy A O E O 40 11/28/2 (田