homework 1

xlsx

School

Illinois Institute Of Technology *

*We aren’t endorsed by this school

Course

523

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

14

Uploaded by UltraFreedomHare37

Report
Jackson's Bright Ideas Monthly Balances Due Report Customer Credits Payments Purchases Service Charge Costa, Dan $160.68 $18.70 $99.33 $68.28 $1.17 Hernandez, Abraham $138.11 $48.47 $75.81 $46.72 $0.38 Mc Cartan, John $820.15 $32.11 $31.23 $29.19 $20.81 Paoli, Pam $167.35 $59.32 $52.91 $33.90 $1.52 Ramirez, Alberto $568.34 $55.17 $18.53 $36.34 $13.60 Vaughn, Noah $449.92 $25.90 $82.05 $99.77 $9.40 Xiong, James $390.73 $48.12 $19.35 $92.13 $8.89 Total $2,695.28 $287.79 $379.21 $406.33 $55.78 Highest $820.15 $59.32 $99.33 $99.77 $20.81 Lowest $138.11 $18.70 $18.53 $29.19 $0.38 Average $385.04 $41.11 $54.17 $58.05 $7.97 Beginning Balance
New Balance $112.10 $60.93 $806.81 $90.54 $544.58 $451.14 $424.28 $2,490.39 $806.81 $60.93 $355.77
WarmWear 2021 Sales Report PolyFleece Mitts Month Region 1 Region 2 Region 3 Region 4 Region 5 Jan 1,150 1,690 930 2,850 1,210 Feb 1,100 2,200 680 2,340 1,100 Mar 1,070 1,290 960 2,740 1,180 Apr 780 1,520 720 2,170 1,180 May 1,070 1,370 700 1,940 1,210 Jun 670 1,300 780 3,430 1,170 Jul 1,390 1,590 1,240 2,230 1,430 Aug 1,310 1,730 610 2,560 960 Sep 1,100 1,820 370 3,040 1,100 Oct 1,350 2,010 750 2,430 1,230 Nov 680 1,620 780 3,210 1,230 Dec 1,120 1,170 670 1,920 1,310 Total 12,790 19,310 9,190 30,860 14,310 ArticBlast Gloves Month Region 1 Region 2 Region 3 Region 4 Region 5 Jan 790 1,160 620 2,590 760 Feb 1,010 1,170 610 1,950 1,010 Mar 710 1,270 600 2,050 930 Apr 890 1,190 750 2,030 980 May 990 1,340 660 2,670 1,040 Jun 990 1,280 620 2,330 800 Jul 780 1,180 690 2,260 920 Aug 800 1,220 560 2,460 900 Sep 810 1,150 670 2,500 970 Oct 760 1,070 630 2,350 1,040 Nov 770 1,140 630 2,540 1,080 Dec 850 1,370 590 2,490 1,060 Total 10,150 14,540 7,630 28,220 11,490 Glomitts Month Region 1 Region 2 Region 3 Region 4 Region 5 Jan 340 780 280 1,670 600 Feb 460 810 280 1,770 480 Mar 410 820 310 1,490 460 Apr 490 890 330 1,610 650 May 470 960 290 1,580 540 Jun 480 740 340 1,780 640 Jul 470 760 320 1,500 640 Aug 490 690 340 1,610 600 Sep 420 780 340 1,660 680 Oct 460 820 350 1,800 660 Nov 550 830 440 1,250 590 Dec 400 790 220 1,620 540 Total 5,440 9,670 3,840 19,340 7,080
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Average Total 1,566 7,830 1,484 7,420 1,448 7,240 1,274 6,370 1,258 6,290 1,470 7,350 1,576 7,880 1,434 7,170 1,486 7,430 1,554 7,770 1,504 7,520 1,238 6,190 17,292 86,460 Average Total 1,184 5,920 1,150 5,750 1,112 5,560 1,168 5,840 1,340 6,700 1,204 6,020 1,166 5,830 1,188 5,940 1,220 6,100 1,170 5,850 1,232 6,160 1,272 6,360 14,406 72,030 Average Total 734 3,670 760 3,800 698 3,490 794 3,970 768 3,840 796 3,980 738 3,690 746 3,730 776 3,880 818 4,090 732 3,660 714 3,570 9,074 45,370
Inspired Endeavors Projected Cash Flows Units Sold Revenues Expenses Net Income Revenue 29,200 $846,800 $712,439 $134,361 Units Sold $29,200 15,000 $435,000 $508,023 -$73,023 Price per Unit $29 20,000 $580,000 $580,000 $0 Total Revenue $846,800 25,000 $725,000 $651,978 $73,023 30,000 $870,000 $723,955 $146,045 Variable Expenses 35,000 $1,015,000 $795,933 $219,068 Units Produced $30,660 40,000 $1,160,000 $867,910 $292,090 Material Cost per Unit $9 Total Material Cost $260,610 Manufacturing Cost per Unit $5 Total Manufacturing Cost $159,739 Total Variable Expenses $420,349 Fixed Expenses Salaries and Benefits $240,000 Advertising $25,000 Administrative $15,000 Miscellaneous $12,090 Total Fixed Expenses $292,090 Summary Projected Total Revenue $846,800 Total Expenses $712,439 Net Income $134,361 Breakeven Point (Algebraic Soluti $20,000 Revenue (Units Sold) - Variable Expenses (Units Sold) - Fixed Expenses = 0 15,000 20,000 25,000 30,000 35,000 40,000 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 EXPENSE-REVENUE RELATIONSHIP Revenue Expenses
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
X Y $20,000 $0 $20,000 $1,160,000
Inspired Endeavors Projected Cash Flows Units Sold Revenue 29,200 Units Sold $29,200 15,000 Price per Unit $29 20,000 Total Revenue $846,800 25,000 30,000 Variable Expenses 35,000 Units Produced $30,660 40,000 Material Cost per Unit $9 Total Material Cost $260,610 Manufacturing Cost per Unit $5 Total Manufacturing Cost $159,739 Total Variable Expenses $420,349 Fixed Expenses Salaries and Benefits $240,000 Advertising $25,000 Administrative $15,000 Miscellaneous $12,090 Total Fixed Expenses $292,090 Summary Projected Total Revenue $846,800 Total Expenses $712,439 Net Income $134,361 Breakeven Point (Algebraic Solut $20,000 Revenue (Units Sold) - Variable Expenses (Units Sold) - Fixed Expenses = 0 10,000 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000
Revenues Expenses Net Income $846,800 $712,439 $134,361 $435,000 $508,023 -$73,023 $580,000 $580,000 $0 $725,000 $651,978 $73,023 $870,000 $723,955 $146,045 $1,015,000 $795,933 $219,068 $1,160,000 $867,910 $292,090 15,000 20,000 25,000 30,000 35,000 40,000 45,000 expense revenue relationship Revenue Expenses Breakeven point
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
X Y 20000 0 20000 1160000
Personal Budget Income Ending C Salary $4,500.00 Salary Fixed Expenses 4000 Rent/Mortgage $2,000.00 4150 Loans $500.00 4300 Car Payment $436.29 4450 Netflix $12.95 4600 Water $50.00 4750 Gas Company $125.00 4900 Cable $110.00 5050 Cell Phone Company $60.00 5200 Total Fixed Bills: ### 5350 5500 Flexible Expenses 5650 Food and Household Supp $600.00 5800 Transit Pass $149.75 5950 Pet Food $100.00 6100 Gas $60.00 Personal Spending Money $150.00 Flexible Household Total: ### Off-Budget Expenses Surprises (like car repairs) $100.00 Medical/Vet Yarn and wine $25.00 Other/Misc. $200.00 Misc. 2 Misc. 3 Off-Budget Total: $325.00 Grand Total Spending: $4,678.99 Cash Extra or Short: -$178.99 Breakeven Takehome Salary
$4,500.00 Cash -$178.99 -$178.99 1500 1650 1800 -678.99 4000 Err:504 Err:504 Err:504 -528.99 4250 Err:504 Err:504 Err:504 -378.99 4500 Err:504 Err:504 Err:504 -228.99 4750 Err:504 Err:504 Err:504 -78.99 5000 Err:504 Err:504 Err:504 71.01 5250 Err:504 Err:504 Err:504 221.01 5500 Err:504 Err:504 Err:504 371.01 5750 Err:504 Err:504 Err:504 521.01 671.01 821.01 971.01 1121.01 1271.01 1421.01
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Salary & Rent /Mortgage Combination 1950 2100 2250 2400 2550 2700 2850 3000 3150 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
3300 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504

Related Documents

Chapter 11 - McGrawHill Exercises.xlsx
JWI530_Week 4 Discussion.docx
Week Four Discussion (2).docx
Week 4 Discussion.docx
HW7 - FIN 655.pdf
HW4 - FIN 655.pdf
FNSFMB512 - Client Project #1 (Suzie and Martin Connor) - Case Study Questions v1.0.docx
Module 3 Chapter-F2F.docx
Module 6 SSGC Case Part B SAMPLE_Solution_F22.xlsx
Client Profile #3.docx
Copy of JWI 530 Assignment 2.xlsx
OHS8035 Week 5 In Class Activity Hazard and Risk Evaluation by Vivek Surve.pdf
Related Questions
Next Question Find the credit-card sales less refunds for the Sales/Refund record for 09/24/10. 24/10 Sales Refunds ..... $71.86 $451.59 The credit-card sales less refunds for 09/24/10 is $ $76.53 $85.04 $149.72 $115.02 $81.45 $88.49 $30.75 $111.02 $229.23 $254.84 $162.81
Next Question Find the total amount of the credit-card sales on the record for the date 09/24/10. 24/10 Sales Refunds $72.29 $488.57 The total of the credit-card sales for 09/24/10 is $ $72.37 $91.62 $180.47 $184.67 $52.32 $91.41 $75.09 $291.95 $135.36 $126.67 $258.07
Calculate the monthly service charge to a business that had an average balance of $729 and wrote 40 checks. EIT Average Balance Maintenance Charge Per Check Charge $5000 $0.00 $0.00 ..... The monthly service charge is $
Figure 7.1. Department Store Statement for Jessica Horowitz Reference Posting Date Description Purchases & Payments & Advances Credits 7651209 6/25 Juniors Housewares Childrens PAYMENT $132.76 4111202 6/27 32.10 3245009 6/28 45.66 1371107 6/29 $175.00 Billing Period Previous Balance Periodic Rate Finance Charge Average Daily Balance 6/1 - 6/30 $215.00 1.5% $123.09 Payments & Credits Purchases & New Minimum Payment Advances Balance Payment Due $175.00 $25.00 7/25 Use Figure 7.1 What is the unpaid balance on Jessica's account? Select one: a. $215.00 b. $132.76 C. $40.00 d. $123.09
Dog
What is the average collection period solve this accounting questions
Next Question 24/10 Find the amount of the credit given to the business, based on the Sales/Refunds record for 09/24/10, after the 2.25% fee is subtracted. Sales Refunds $82.84 $32.06 $69.45 ..... $434.45 $69.19 $235.87 The total amount of credit will be $ $108.53 $123.32 (Round to the nearest cent as needed.) $60.85 $86.23 $139.47 $288.49 $150.28
TB 08 - 56 Accounts receivable accounts for specific cu... Accounts receivable accounts for specific customers are important because they show Multiple Choice How much each customer paid All of the choices are correct How much each customer still owes The basis for sending bills to customers How much each customer purchases
Create a Ledger for the Journal Entry General Journal     Page 1 Date Description Post Ref. Dr Cr 2023           Mar. 2 Cash   750       Account Receivables     750     To record payment for AR         4 Cash   170       Account Receivables     170     To record payment for AR         6 Account Receivables   1755       Sales     1755     To record Sales         7 Account Receivables   620       Sales     620     To record Sales           Cash   875       Sales     875     To record Sales           Promotion   690       Cash     690     To record payment for promotion         8 Cash   215       Account Receivables     215     To record payment for AR           Promotion   215       Cash     215     To record payment for promotion           Purchase   2017       Cash     2017     To record purchase of tshirts w/df         9 Promotion   700       Cash     700     To record payment for promotion         10 Account…
Mountain top hardware by kirk lynch. i need someones help who has done this assignment. With the general journal.
Dineshbhai Don't upload image please
Show solution please thanks
hello tutor please help me
EM6.11 Pay Credit Card Mookie the Beagle Concierge makes a payment on the VISA credit card on 01/31/2023 in the amount of $800. Required: To record the payment on the VISA credit card: From the Navigation Bar, select Expenses > select Expenses tab From the New transaction drop-down menu, select Pay down credit card For Which credit card did you pay?, select 2100 VISA Credit Card For How much did you pay?, enter 800.00 For Date of payment, enter 01/31/2023 For What did you use to make this payment?, select 1001 Checking Select Save and close What is the balance of the VISA Credit Card account after the credit card payment is recorded? Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount.
If Abby INC sells items to a customer who uses a credit card for $1100 and there is a credit card fee of 1.5% Abby will record an : ______ Round your final answer to the nearest dollar A. DEBIT TO ACCOUNT RECIEABLE FOR $1083 B. Credit to sales revenue for $1083 C. debit to sales expense for $17 D. Debit to credit card discount expense for $17
I need question 3-6 if that is okay
Post the transactions from each journal provided, Sales, Cash Receipts and General, into the appropriate customer accounts in the Accounts Receivable Subsidiary ledger. Each journal.
Quesiotn attached thanks for the help 1l3pt13pg13lpg41lhp2oth2tpoh2 arg leol
Make a general ledger for each account title from the general journal below.
Important Note! Before you start working on this problem, watch the Hint video. This video shows you exactly how to work this problem. Compute the amount to be paid for each of the four separate invoices assuming that all invoices are paid within the discount period a. b. Merchandise (gross) $ S C. $ d. $ 7,800 24,200 80.600 17,000 Terms 2/10, n/60 1/15, n/90 1/10, n/30 3/15, n/45 Payment
Need help with 15, 17, and 19. Thanks!
A v2.cengagenow.com/ilrn/takeAssignment/takeASsig pps Gmail YouTube A Maps New Folder am 3 Enter the following transactions in a cash receipts journal. Use a 5% sales tax rate. Total and rule the journal. If an amount box does not require an entry, leave it blank. Feb. 2 John Door made an $890 payment on account. 7 Cash sales for the week, $2,140, plus sales tax. 11 Tom Chovin made a $600 payment on account. 14 Grace Borsetti made a $1,540 payment on account. 18 Cash sales for the week, $2,300, plus sales tax. 24 Peter Chan paid $540 on account. 28 Jean Amore paid $350 on account. CASH RECEIPTS JOURNAL Page 1 Accounts Sales Tax Account General Receivable Sales Payable Cash Date Credited Post. Ref. Credit Credit Credit Credit Debit Feb. 2 John Door 890 890 7 Cash sales 2,140 107 2,247 11 Tom Chovin 600 600 14 Grace Borsetti 1,540 1,540 18 Cash sales 2,300 115 2,415 24 Peter Chan 540 540 28 Jean Amore 350 350
Review the sales journal below. (Click the icon to view the sales journal.) Read the requirements. Requirement 1. Total each column of the sales journal. Date 2024 Jun. Jun. 1 8 101 Fletcher Jay 102 Iliana Flower 13 103 Jesse Thomas 28 104 George Westerberg 30 Totals 1. 2. Invoice No. Requirements 3. 4. Customer Account Debited Sales Journa Post. Accounts Receivable DR Ref. Sales Revenue CR Total each column of the sales journal. The following four-column accounts in the accounts receivable subsidiary ledger have been opened for you: Accounts Receivable-Flower; Accounts Receivable Jay; Accounts Receivable-Thomas; Accounts Receivable-Westerberg. Post the transactions to the accounts receivable subsidiary ledger. 1,260 2,225 360 900 Print The following selected four-column accounts in the general ledger have been opened for you: Accounts Receivable (112); Merchandise Inventory (118), Bal. $4,800; Sales Revenue (411); Cost of Goods Sold (511). Post the total of each column to the general…
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
Text book image
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Text book image
Century 21 Accounting General Journal
Accounting
ISBN:9781337680059
Author:Gilbertson
Publisher:Cengage
SEE MORE TEXTBOOKS
Related Questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
Text book image
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Text book image
Century 21 Accounting General Journal
Accounting
ISBN:9781337680059
Author:Gilbertson
Publisher:Cengage
SEE MORE TEXTBOOKS