
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
How much inventory should z Mart purchase?

Transcribed Image Text:Z Mart (a retailer) has the following sales forecast:
•
January: $550,000
•
.
February: $650,000
March: $500,000
April: $700,000
Z Mart has a 25% gross margin percentage. Inventory at
January 1 is $75,000. The company intends to keep enough
inventory on hand at the end of each month to cover 25% of
next month's cost of goods sold.
How much inventory (in cost, not units) should Z Mart purchase
in January?
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps

Knowledge Booster
Similar questions
- Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?arrow_forwardLangstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?arrow_forwardAmusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?arrow_forward
- Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?arrow_forwardLogo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement shows cost of goods sold of $2,000. What was the beginning inventory if the ending inventory was $1,000?arrow_forwardOttis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the annual ordering cost. 2. Compute the annual carrying cost. 3. Compute the cost of Ottiss current inventory policy. Is this the minimum cost? Why or why not?arrow_forward
- Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An order to replenish the part requires a lead time of five days. Required: 1. Calculate the reorder point, using Equation 20.3. 2. Graphically display the reorder point, where the vertical axis is inventory (units) and the horizontal axis is time (days). Show two replenishments, beginning at time zero with the economic order quantity in inventory. 3. What if the average usage per day of the part is 500 units but a daily maximum usage of 575 units is possible? What is the reorder point when this demand uncertainty exists?arrow_forwardPietro expects to produce 50,000 units and sell 49,300 units. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Required: 1. Prepare a statement of cost of goods sold in good form. 2. What if the beginning inventory of finished goods decreased by 5,000? What would be the effect on the cost of goods sold?arrow_forwardAll Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?arrow_forward
- Negus Enterprises has an inventory conversion period of 50 days, an average collection period of 35 days, and a payables deferral period of 25 days. Assume that cost of goods sold is 80% of sales. What is the length of the firm’s cash conversion cycle? If annual sales are $4,380,000 and all sales are on credit, what is the firm’s investment in accounts receivable? How many times per year does Negus Enterprises turn over its inventory?arrow_forwardTrumbull Co. plans to produce 100,000 toy cars during September. Planned production for October is 125,000 cars. Sales are forecasted at 90,000 toy cars for September and 120,000 toy cars for October. Each toy car requires four wheels. Trumbulls policy is to maintain 10 percent of the next months production in inventory at the end of a month. How many wheels should Tram bull purchase during September? a. 195,000 b. 112,500 c. 102,500 d. 410,000arrow_forwardWhen prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning