Answered: buds: re purchased at a cost of $6,202…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

See similar textbooks

Related questions

Concept explainers

Question

Please answer all

Transcribed Image Text:SOUND CORE WIRELESS sells a variety of mobile telephone accessories including several brands of Wireless Earbuds Bluetooth Headphones. The earbuds are sold in cases, with each case containing a pair of earbuds. SOUND CORE began the last quarter (October to December) of 2021 with 30 cases of the (TOZO T6) earbuds at a total cost of $187,800. During the quarter the business completed the following transactions relating to the "TOZO T6" earbuds: October 8 98 cases were purchased at a cost of $6,202 each. In addition, the business paid a freight charge of $248 cash on each case to have the inventory shipped from the point of purchase to their place of business. October 31 The sales for October were 85 cases which yielded total sales revenue of $809,030. (25 of these cases were sold on account to three longstanding customers) November 4 A new batch of 67 cases was purchased at a total cost of $465,650 November 10 5 of the cases purchased on November 4 were returned to the supplier, as they were not of the type nor model ordered. During the month 60 cases were sold at a price of $10,350 each. November 30 December 4 A customer, to whom 9 cases were sold during the first business day of November, returned 3 of the cases, as they were of another make and model. Owing to an increased demand, a further 115 cases were purchased at a cost of $7,900 each; these were subject to a trade discount of 2% each December 10 December 30 121 cases were sold during December at a unit selling price of $11,085. December 31 An actual count of inventory was carried out which revealed that there were 34 cases of the "TOZO T6" brand of merchandise in the store room. Unless otherwise stated, assume that all purchases were on account and received on the dates stated. Required: (D) The West Indies School Book Shop sells T Shirts emblazoned with the school's name and logo. The shirts cost $2,000 each and management estimates that 900 T Shirts will be sold during each month of the year. The annual holding cost for a unit of that inventory is estimated to be 1.5% of the purchase price. It costs the Book Shop $500 to place a single order. The maximum sale for the Book Shop for any one week is 300 shirts and minimum sales 150 shirts. The supplier takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. i) Determine the highest number of shirts that should be purchased by the Gift Shop in order to minimize stock administration cost. ii) What is the total stock administration costs? iii)Using the EOQ policy, determine the re-order level, minimum inventory level and maximum inventory level for the T Shirts.

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions