Angelys9462Aged Payable Report
.xlsx
keyboard_arrow_up
School
National University College *
*We aren’t endorsed by this school
Course
2100
Subject
Business
Date
Jul 2, 2024
Type
xlsx
Pages
2
Uploaded by angelysj317
Filter Criteria includes: 1) Includes Drop Shipments. Report order is by ID. Report is printed in Detail Format. Angelys9462
Aged Payables
As of 31 Mar 2024
Page: 1
Vendor ID
Vendor
Contact
Telephone 1
Invoice/CM #
0 - 30
31 - 60
AC
Alta costura
Migdalia Velez
7879737344
101
1,275.00
AC
Alta costura
1,275.00 EM
Embeleco
Vanessa Perez
7876213434
102
200.00
EM
Embeleco
200.00 LO
Lola
Raquel Galindo
7879738547
103
1,200.00
LO
Lola
1,200.00 TE
Telas y mas
Mildred Vazquez
7877558242
104
887.50
TE
Telas y mas
887.50 Report Total
3,562.50
Filter Criteria includes: 1) Includes Drop Shipments. Report order is by ID. Report is printed in Detail Format. Angelys9462
Aged Payables
As of 31 Mar 2024
Page: 2
61 - 90
Over 90 days
Amount Due
1,275.00
1,275.00
200.00
200.00
1,200.00
1,200.00
887.50
887.50
3,562.50
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
Related Questions
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods
The units of an item available for sale during the year were as follows:
Jan. 1
Inventory
15
units at $40
$600
Aug. 13
Purchase
5
units at $41
205
Nov. 30
Purchase
11
units at $42
462
Available for sale
31
units
$1,267
There are 9 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar).
a.
First-in, first-out (FIFO)
$fill in the blank 1
b.
Last-in, first-out (LIFO)
$fill in the blank 2
c.
Weighted average cost
$fill in the blank 3
arrow_forward
Complete Company A's table
ItemList priceChain discountNet priceTrade discountPrecor treadmill$3,0009/4 Maytag Dishwasher$4508/5/6 Hewlett-Packard Scanner$3203/5/9 Land Cruiser roof rack$1,85012/9.6
arrow_forward
ABC analysis on the following set of products
Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75
Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
arrow_forward
Q4. What are the various types of inventory? Explain each type in brief.
arrow_forward
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods
The units of an item available for sale during the year were as follows:
12 units at $47
Jan. 11
Aug. 13
20 units at $48
Nov. 30
$564
960
735
Avaliable for sale
$2,259
There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout
(LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar).
a First-in, first-out (FIFO)
b.
Last-in, first-out (LIFO)
c. Weighted average cost
Inventory
Purchase
Purchase
15 units at $49
47 units
1,284 X
arrow_forward
19. SPRAY-PAINT INVENTORY The Graphic Hobby House made purchases of assorted
colors of spray paint during the year as follows.
Beginning inventory 200 cans at $2.20
March 400 cans at $2.40
May 700 cans at $2.00
August 500 cans at $2.30
November 300 cans at S2.60
At the end of the year, they had 450 cans of spray paint in stock.
(a) Find the inventory value using the weighted-average method.
(b) Find the inventory value using the FIFO method.
(c) Find the inventory value using the LIFO method.
arrow_forward
Specialty Toys, Inc., sells a variety of new and innovative children's toys. As with other products, Specialty faces the decision of how may Weather Teddy units to order for coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team ask you for analysis of the stock-out probabilities for various order quantities, an estimate of the product potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty%u2019s sales forecaster predicted and expected demand of 20,000 units with a .95 probability that demand would be between 10,000 units and…
arrow_forward
b. Forward Thinking Limited (FTL) has used a fixed-time period inventory system that involvedtaking a complete inventory count of all items each month. However, increasing labor costs, areforcing FTL, to examine alternative ways to reduce the amount of labour involved in inventorystockrooms, yet without increasing other costs, such a shortage costs. Table 4 (below) is arandom sample of 20 FTL’s items.6Table 4. Annual Usage by Value of a sample of FTL’s InventoryItem Number Annual Usage ($) Item Number Annual Usage ($)1 10,700 11 2,8502 14,100 12 1,5003 4,100 13 3,3004 16,100 14 2,6005 8,200 15 110,1006 1,900 16 14,9007 84,100 17 9,6008 990 18 1,8009 1040 19 3,80010 94,100 20 12,600
(i) What would you recommend FTL to do to cut back its labor cost? (Illustrate using an ABCplan).
arrow_forward
11.
Determine planned purchases (a) at retail and (b) at cost for a month with the following planned figures: Round to the nearest dollar.
Sales $148,000
Markdowns 8,400
BOM Stock 310,500
EOM Stock 340,000
Markup 48%
arrow_forward
PLZ I want full answer with all solution steps
arrow_forward
Q3. What is inventory management? Explain in brief 4 functions of inventory management.
arrow_forward
OPL
arrow_forward
Give the correct answer
arrow_forward
Beginning Quantity
Ending
Inventory Order? Lost
Week
Demand
inventory
on-order
inventory
position (yes/no) Sales
1
100
53
2
40
3
36
4
38
5
55
6
34
7
30
8
31
9
40
10
57
11
30
12
53
arrow_forward
Q-. Explain the following concepts.
Wholesaler
Fire Insurance
Short Term Finance
Indirect Channel
arrow_forward
Decide on at least three distinct parties involved in the requirements collecting process
arrow_forward
3. Fortnex is a company that assembles small household appliances including coffee
makers, toasters, and food mixers. The parent company of Fortnex has been concerned
about the rising product cost of the finished products, which has led to reduced profit
margins. One of the demands of the parent company has been to review the inventory
management practices of Fortnex. Two areas which Fortnex is currently investigating are
economic order quantity EOQ and ABC analysis. Perform the following.
(i)
At present the company purchases copper wire for a certain appliance under
economic order quantities based on the information given in Table 3-1. The
supplier of copper wire is proposing a discount of 5% of unit price if Fortnex
purchases in lot sizes of 1000 kg. rather than the calculated EOQ. Determine if
Fortnex should take advantage of the price discount. Justify your response.
For a particular series of referenced products, the number of units used a year,
and the unit cost are as shown in…
arrow_forward
Question1: A business wants to classify its inventory items in order to determine its inventory policy. The table contains information about the inventory items in the business. Accordingly, using the "ABC" analysis, determine the stock groups of the enterprise.1-) What percentage of the total inventory items and total inventory costs will the A group inventory items constitute?2-) What percentage of the total inventory items and total inventory costs will the B group inventory items constitute?3-) What percentage of the total inventory items and total inventory costs will the C group inventory items constitute?
arrow_forward
Please do not give solution in image format thanku
1) Determine which shipping alternative would be most economical to ship 80 boxes of parts when each box has a price of $200 and holding costs are 30 percent of price, given this shipping information: overnight, $300, two-day, $260, six-day, $180.
arrow_forward
Please fill out the table of values.
arrow_forward
can you please help me answer this question....
Rebar Company prepared the following analysis of its year-end inventory on December 31. First, determine the total lower of cost or market value for each product in Rebar Company's inventory. Second, prepare the journal entry needed at year-end to value the inventory at LCM, if applicable.
Historical Cost
Replacement Cost
Product
Quantity
per unit
per unit
A
17
$430
$499
B
140
325
299
C
38
75
69
arrow_forward
Subject:- accounting
arrow_forward
Can you assist me with Question 12.3. Please right out the steps it's easier to understand verses on the excel spreadsheet. If you do it in excel can you make it easy to follow along to. Thank you kindly.
arrow_forward
Q6. Discuss the challenges and opportunities of multichannel distribution system highlighting the keyfunctions performed by them.
arrow_forward
***** The company Marombeiro is a commercial representative of a food supplement widely consumed in gyms. The average daily demand for the product is 1,500 units and a standard deviation of 300 units. Average shipping time is 5 days. Of course, if the order is placed at the end of the week, it may take a little longer to receive the shipment, so the standard deviation of the delivery time is 2 days. The unit has a value of R$ 50.00 per unit in stock, an order cost of R$ 50.00 and an annual maintenance fee of 20%. Suppose Company Marombeiro wants to change the service to 99%. How many days of safety stock the company will have.
( )5.12 days
( )5.67 days
( )5.33 days
( )4.77 days
arrow_forward
part 2 solution needed
arrow_forward
When a customer allows the supplier to manage inventory policy for an item or group of items.
arrow_forward
I don’t understand
arrow_forward
How would you adjust MPS schedule when safety stock requirements are given?
arrow_forward
ECUR
UMIC ORDER QUANTITY CALCULATIONS (2 QUESTIONS)
Company uses 800 units of a product per year on a continuous basis. The product
year and order costs of $300 per order. It takes 30 days to receive a shipment after an order is placed and the
a safety stock of 5 days usage in inventory.
has carrying costs of $50
A. Calculate the economic order
quantity
a. 98
B. Determine the reorder
a. 150 days
(3
CASH DISCOUNTS
point.
ONS)
(Assume
(EOQ).
a 360-day year.)
per
unit per
firm requires
arrow_forward
What is the purpose of inventory control?
arrow_forward
Question Two (2)
Explain why procurement planning should always be done in a rational manner.
Discuss why contract packaging is an essential part of the design during a procurement proceeding?
arrow_forward
Micro-Electronics Warehouse Headset and Webcam Sale
Item
Type
Reg. Price
After Savings Price
BuddyChat 200
Headset
$34.72
$24.40
BuddyChat 300
Headset
$41.27
$34.91
BuddyCam HD
Webcam
$83.54
$61.46
You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
arrow_forward
Watergate, Inc. uses a perpetual inventory system. It entered into the following purchases and
sales transactions. Use this information to answer the questions that follow.
Date
Watergate, Inc. Inventory
Activities
Oct. 1
Beginning Inventory
Oct. 5
Purchase
Oct. 9
Sale
Oct. 18
Purchase
Oct. 24
Sale
Details
110 units @ $20
50 units @ $22
60 units @ $40
70 units @ $25
55 units @ $40
Question 1
Watergate, Inc.: Assuming FIFO inventory method answer the following:
1. Total cost of goods sold at the end of the period.
2. Ending inventory in dollars not units at the end of the period.
3. Gross profit for the period.
Question 2
Watergate, Inc.: Assuming LIFO inventory method answer the following:
1. Total cost of goods sold at the end of the period.
2. Ending inventory in dollars not units at the end of the period.
3. Gross profit for the period.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Related Questions
- Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $40 $600 Aug. 13 Purchase 5 units at $41 205 Nov. 30 Purchase 11 units at $42 462 Available for sale 31 units $1,267 There are 9 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a. First-in, first-out (FIFO) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3arrow_forwardComplete Company A's table ItemList priceChain discountNet priceTrade discountPrecor treadmill$3,0009/4 Maytag Dishwasher$4508/5/6 Hewlett-Packard Scanner$3203/5/9 Land Cruiser roof rack$1,85012/9.6arrow_forwardABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.arrow_forward
- Q4. What are the various types of inventory? Explain each type in brief.arrow_forwardPeriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 Xarrow_forward19. SPRAY-PAINT INVENTORY The Graphic Hobby House made purchases of assorted colors of spray paint during the year as follows. Beginning inventory 200 cans at $2.20 March 400 cans at $2.40 May 700 cans at $2.00 August 500 cans at $2.30 November 300 cans at S2.60 At the end of the year, they had 450 cans of spray paint in stock. (a) Find the inventory value using the weighted-average method. (b) Find the inventory value using the FIFO method. (c) Find the inventory value using the LIFO method.arrow_forward
- Specialty Toys, Inc., sells a variety of new and innovative children's toys. As with other products, Specialty faces the decision of how may Weather Teddy units to order for coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team ask you for analysis of the stock-out probabilities for various order quantities, an estimate of the product potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty%u2019s sales forecaster predicted and expected demand of 20,000 units with a .95 probability that demand would be between 10,000 units and…arrow_forwardb. Forward Thinking Limited (FTL) has used a fixed-time period inventory system that involvedtaking a complete inventory count of all items each month. However, increasing labor costs, areforcing FTL, to examine alternative ways to reduce the amount of labour involved in inventorystockrooms, yet without increasing other costs, such a shortage costs. Table 4 (below) is arandom sample of 20 FTL’s items.6Table 4. Annual Usage by Value of a sample of FTL’s InventoryItem Number Annual Usage ($) Item Number Annual Usage ($)1 10,700 11 2,8502 14,100 12 1,5003 4,100 13 3,3004 16,100 14 2,6005 8,200 15 110,1006 1,900 16 14,9007 84,100 17 9,6008 990 18 1,8009 1040 19 3,80010 94,100 20 12,600 (i) What would you recommend FTL to do to cut back its labor cost? (Illustrate using an ABCplan).arrow_forward11. Determine planned purchases (a) at retail and (b) at cost for a month with the following planned figures: Round to the nearest dollar. Sales $148,000 Markdowns 8,400 BOM Stock 310,500 EOM Stock 340,000 Markup 48%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage LearningEssentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage LearningAccounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
- International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education