Question 7:
PLease, write the answer in Word format with Formulae written
(i) Khaled’s sales in August and September were $100,000 and $200,000 respectively. Forecasted Sales for October, November, and December are as below: October - $400,000 November - $300,000 December - $200,000
30% of the firm’s sales have been for cash, 50% have been collected after 1 month, and the remaining 20% after 2 months. Bad-debt expenses (uncollectible accounts) have been negligible. In December, Khaled will receive a $30,000 dividend from stock in a subsidiary.
(ii) Khaled has also gathered the relevant information for the development of a cash disbursement schedule. Purchases will represent 70% of sales - 40% will be paid immediately in cash, 60% is paid the month following the purchase. The firm will also expend cash on rent, wages and salaries every month of $52,000.
Prepare a Cash Budget for October, November and December.
Answer (a)
(i). Deduct. Inventory included in inventory which is held for consignment shall be deducted. Therefore $35,000 will be added to $200,000.
(ii). Add. The inventory which is in transit on free on board shipping point basis will be deemed to be the inventory of H company because the ownership is transferred since the date of shipment. $20,000 is required to be
(iii). No effect. Inventory that is sold on free on board basis and on consignment shall not become part of the company's inventory. Hence, $18,000 shall have no inclusion in the inventory valuation.
Ultimate inventory which is required to be reported is ($200,000-$35,000+$20,000) $185,000.
Question 7: PLease, write the answer in Word format with Formulae written Hasbeen Company completed its...
A) Asha Company completed its inventory count. It arrived at a total inventory value of $200,000. You have been given the information listed below. Discuss how this information affects the reported cost of inventory. i. Asha included in the inventory goods held on consignment for Falls Co., costing $35,000. ii. The company did not include in the count purchased goods of $20,000, which were in transit (terms: FOB shipping point). iii. The company did not include in the count inventory...
Sheldon Company just took its physical inventory on December 31. The count of inventory items on hand at the company’s business locations resulted in a total inventory cost of $300,000. In reviewing the details of the count and related inventory transactions, you have discovered the following items that had not been considered. 1. Sheldon Company has sent inventory costing $28,000 on consignment to Richfield Company. All of this inventory was at Richfield’s showrooms on December 31. 2. The company did...
Marigold Corp. just took its physical inventory on December 31. The count of inventory items on hand at the company’s business locations resulted in a total inventory cost of $305,400. In reviewing the details of the count and related inventory transactions, you have discovered the following items that had not been considered. 1. Marigold Corp. has sent inventory costing $28,320 on consignment to Richfield Company. All of this inventory was at Richfield’s showrooms on December 31. 2. The company did...
Travis Company has just completed a physical Inventory count at year-end, December 31 of the current year. Only the items on the shelves, in storage, and in the receiving area were counted and costed on a FIFO basis. The inventory amounted to $65,700. During the audit, the independent CPA developed the following additional Information a Goods costing $870 were being used by a customer on a trial basis and were excluded from the inventory count at December 31 of the...
Travis Company has just completed a physical Inventory count at year-end, December 31 or the current year. Only the items on the shelves, in storage, and in the receiving area were counted and costed on a FIFO basis. The inventory amounted to 565,700. During the audit, the independent CPA developed the following additional Information: a. Goods costing $870 were being used by a customer on a trial basis and were excluded from the inventory count at December 31 of the...
Travis Company has just completed a physical inventory count at year-end, December 31 of the current year. Only the items on the shelves, in storage, and in the receiving area were counted and costed on a FIFO basis. The inventory amounted to $67,000. During the audit, the independent CPA developed the following additional information: a. Goods costing $950 were being used by a customer on a trial basis and were excluded from the inventory count at December 31 of the...
P7-1 (Algo) Analyzing Items to Be Included in Inventory L07-1 Travis Company has just completed a physical inventory count at year-end, December 31 of the current year. Only the items on the shelves, in storage, and in the receiving area were counted and costed on a FIFO basis. The inventory amounted to $67,000. During the audit, the independent CPA developed the following additional information: a. Goods costing $810 were being used by a customer on a trial basis and were...
The inventory on hand of Hayes Company at the end of 2020 determined by physical count is $105,400. The following items were not included in this inventory amount. a. Purchased goods in transit with the terms FOB shipping point, invoice $4100 plus freight $240. b.Goods on out on consignment to Marlman Company, retail sales price $4200. c. Goods sold to Grina Inc. with terms FOB destination invoiced for $1900. Freight to deliver the goods was $150 and the goods were...
Vonn Company, a furniture store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the quarter: As of the end of the prior quarter, September 30, the company’s general ledger showed the following account balances: Cash $62,000 (debit) Accounts receivable $480,000 (debit) Inventory $78,000 (debit) Buildings and equipment, net $570,000 (debit) Accounts payable $193,000 (credit) Capital stock $300,000 (credit) Retained earnings $619,000 (credit) Actual sales for September...
E7-1 LO7-1 Analyzing Items to Be Included in Inventory Based on its physical count of inventory in its warehouse at yearend, December 31 of the current year, Plummer Company planned to report inventory of $34,000. During the audit, the independent CPA devel oped the following additional information: a. Goods from a supplier costing $700 are in transit with UPS on December 31 of the current year. The terms are FOB shipping point (explained in the Required" section). Because these goods...