LIFO Perpetual Inventory
The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a three-month period ending June 30 are as follows:
| Date | Transaction | Number of Units |
Per Unit | Total | ||||
|---|---|---|---|---|---|---|---|---|
| Apr. 3 | Inventory | 48 | $150 | $7,200 | ||||
| 8 | Purchase | 96 | 180 | 17,280 | ||||
| 11 | Sale | 64 | 500 | 32,000 | ||||
| 30 | Sale | 40 | 500 | 20,000 | ||||
| May 8 | Purchase | 80 | 200 | 16,000 | ||||
| 10 | Sale | 48 | 500 | 24,000 | ||||
| 19 | Sale | 24 | 500 | 12,000 | ||||
| 28 | Purchase | 80 | 220 | 17,600 | ||||
| June 5 | Sale | 48 | 525 | 25,200 | ||||
| 16 | Sale | 64 | 525 | 33,600 | ||||
| 21 | Purchase | 144 | 240 | 34,560 | ||||
| 28 | Sale | 72 | 525 | 37,800 | ||||
Required:
1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Rhodes Co. Perpetual Inventory Account LIFO Method For the three-months ended June 30 |
|||||||||
|---|---|---|---|---|---|---|---|---|---|
| Purchases | Cost of Merchandise Sold | Inventory | |||||||
| Date | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
| Apr. 3 | fill in the blank 1 | $fill in the blank 2 | $fill in the blank 3 | ||||||
| Apr. 8 | fill in the blank 4 | $fill in the blank 5 | $fill in the blank 6 | fill in the blank 7 | fill in the blank 8 | fill in the blank 9 | |||
| fill in the blank 10 | fill in the blank 11 | fill in the blank 12 | |||||||
| Apr. 11 | fill in the blank 13 | $fill in the blank 14 | $fill in the blank 15 | fill in the blank 16 | fill in the blank 17 | fill in the blank 18 | |||
| fill in the blank 19 | fill in the blank 20 | fill in the blank 21 | |||||||
| Apr. 30 | fill in the blank 22 | fill in the blank 23 | fill in the blank 24 | fill in the blank 25 | fill in the blank 26 | fill in the blank 27 | |||
| fill in the blank 28 | fill in the blank 29 | fill in the blank 30 | |||||||
| May 8 | fill in the blank 31 | fill in the blank 32 | fill in the blank 33 | fill in the blank 34 | fill in the blank 35 | fill in the blank 36 | |||
| fill in the blank 37 | fill in the blank 38 | fill in the blank 39 | |||||||
| May 10 | fill in the blank 40 | fill in the blank 41 | fill in the blank 42 | fill in the blank 43 | fill in the blank 44 | fill in the blank 45 | |||
| fill in the blank 46 | fill in the blank 47 | fill in the blank 48 | |||||||
| May 19 | fill in the blank 49 | fill in the blank 50 | fill in the blank 51 | fill in the blank 52 | fill in the blank 53 | fill in the blank 54 | |||
| fill in the blank 55 | fill in the blank 56 | fill in the blank 57 | |||||||
| May 28 | fill in the blank 58 | fill in the blank 59 | fill in the blank 60 | fill in the blank 61 | fill in the blank 62 | fill in the blank 63 | |||
| fill in the blank 64 | fill in the blank 65 | fill in the blank 66 | |||||||
| fill in the blank 67 | fill in the blank 68 | fill in the blank 69 | |||||||
| June 5 | fill in the blank 70 | fill in the blank 71 | fill in the blank 72 | fill in the blank 73 | fill in the blank 74 | fill in the blank 75 | |||
| fill in the blank 76 | fill in the blank 77 | fill in the blank 78 | |||||||
| fill in the blank 79 | fill in the blank 80 | fill in the blank 81 | |||||||
| June 16 | fill in the blank 82 | fill in the blank 83 | fill in the blank 84 | fill in the blank 85 | fill in the blank 86 | fill in the blank 87 | |||
| fill in the blank 88 | fill in the blank 89 | fill in the blank 90 | |||||||
| fill in the blank 91 | fill in the blank 92 | fill in the blank 93 | |||||||
| June 21 | fill in the blank 94 | fill in the blank 95 | fill in the blank 96 | fill in the blank 97 | fill in the blank 98 | fill in the blank 99 | |||
| fill in the blank 100 | fill in the blank 101 | fill in the blank 102 | |||||||
| June 28 | fill in the blank 103 | fill in the blank 104 | fill in the blank 105 | fill in the blank 106 | fill in the blank 107 | fill in the blank 108 | |||
| fill in the blank 109 | fill in the blank 110 | fill in the blank 111 | |||||||
| June 30 | Balances | $fill in the blank 112 | $fill in the blank 113 | ||||||
2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period.
| Total sales | $fill in the blank 114 |
| Total cost of merchandise sold | fill in the blank 115 |
| Gross profit | $fill in the blank 116 |
3. Determine the ending inventory cost on June 30.
In: Accounting
Select one of the options below and create a linear equation to represent the monthly bill for each Plan A and Plan B, you will have two equations, one for each plan. Find the common number of minutes at which both Plan A and Plan B cost the same amount. This number of minutes is called the break-even point. Which plan costs more before the break-even point and which cost more after the break-even point.
Option 1: Plan A $39.99 for 200 min and $1.25 for each min after. Plan B $29.99 for 200 min and $1.50 for each min after.
Option 2: Plan A $25.75 plus $.75 per min. Plan B $20.99 plus $1.00 per min
Option 3: Plan A $39.99 plus $1.25 per min. Plan B $25.99 plus $1.75 per min
Option 4: Plan A $45.99 for 400 min and $.50 for each min after. Plan B $49.99 for 400 min and $.40 for each min after
Use Microsoft Excel spreadsheet to answer.
In: Economics
In a study examining the survival of cancer patients, 100 patients were enrolled at baseline. After one year, 20 patients were known to have died. Assuming no patients were lost to follow-up, what was the probability of surviving one year? (OK to show numerator/denominator)What would be the one-year survival rate in the previous question if ten patients had been lost to follow-up during the first year? Use the life table method.
In: Statistics and Probability
An air-track glider attached to a spring oscillates with a period of 1.50 s . At t=0s the glider is 5.30 cm left of the equilibrium position and moving to the right at 38.5 cm/s .
Part A
What is the phase constant?
Part B
What is the phase at t=.05s?
Part C
What is the phase at t=1s ?
Part D
What is the phase at t=1.5s?
In: Physics
A 4.0-cm-diameter parallel-plate capacitor with a 1.0 mm spacing is charged to 1000 V. A switch closes at t =0s, and the capacitor is discharged through a wire with 0.20? resistance.
Part A
Find an expression for the magnetic field strength inside the capacitor at r =1.0cm as a function of time t (where t is in ps).
Part B
Draw a graph of B versus t.
In: Physics
Mark Ventura has just purchased an annuity to begin payment two years from today. The annuity is for $24,000 per year and is designed to last 7 years. If the interest rate for this problem calculation is 11 percent, what is the most he should have paid for the annuity? Use Appendix B and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Maximum Payment =
In: Finance
Alpha Corporation has been in business for two years. It incurred the following items last year (Year 1): Gross profits on sales 240000 Operating expenses 100000 Long-term capital gain 8000 Short-term capital loss 12000 Alpha reported the following items this year (Year 2): Gross profits on sales 600,000 Operating expenses 165,000 Long term capital gain 10000 Compute Alpha’s taxable income and tax liability for Year 1 and Year 2.
In: Accounting
An insurance company divided its clients into two categories, amateur and professional. The last year accident report shows 10% of amateur drivers and 2.5% of professional drivers are involved in an accident. If 15% of drivers are amateur license and 85% are professional, find the following probabilities. For simplicity, assume year to year accident accidents for any driver are independent.
In: Statistics and Probability
1. Gomez Co. had the following transactions in the last two
months of its year ended December 31st Nov. 1st Paid $1,900 cash
for future newspaper advertising
1st Paid $2,460 cash for 12 months of insurance through October
31st of the next year.
30th Received $3,700 cash for future services to be provided to a
customer.
Dec. Ist Paid $6,000 cash for a consultant's services to be
received over the next three months.
15 Received $7,950 cash for future services to be provided to a
customer
31st Of the advertising paid for on November 1st, $1,500 worth is
not yet used
31st A portion of the insurance paid for on November 1st has
expired. No adjustment was made in November to Prepaid
Insurance
31st Services worth $1,500 are not yet provided to the customer who
paid on November 30.
31st One-third of the consulting services paid for on December 1st
have been received.
31st The company has performed $3,400 of services that the customer
paid for on December 15th.
In: Accounting
An instructor who taught two sections of engineering statistics
last term, the first with 25 students and the second with 30,
decided to assign a term project. After all projects had been
turned in, the instructor randomly ordered them before grading.
Consider the first 15 graded projects.
(b) What is the probability that at least 10 of these are from the
second section? (Round your answer to four decimal places.)
(c) What is the probability that at least 10 of these are from the
same section? (Round your answer to four decimal places.)
(d) What are the mean value and standard deviation of the number
among these 15 that are from the second section? (Round your mean
to the nearest whole number and your standard deviation to three
decimal places.)
| mean | projects |
| standard deviation | projects |
(e) What are the mean value and standard deviation of the number of
projects not among these first 15 that are from the second section?
(Round your mean to the nearest whole number and your standard
deviation to three decimal places.)
| mean | projects |
| standard deviation | projects |
Please answer parts B, C, D, and E
In: Statistics and Probability