Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Internet across the United States. To keep costs down, CGC maintains a warehouse but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year: Expected monthly sales for April, May, June, and July are $160,000, $ 130,000, $250,000, and $70,000, respectively. Cost of goods sold is 50 percent of expected sales. CGC's desired ending inventory is 60 percent of the following month's cost of goods sold. Monthly operating expenses are estimated to be: Salaries: $35,000. Delivery expense: 5 percent of monthly sales. Rent expense on the warehouse: $3,500. Utilities: $700. Insurance: $360. Other expenses: $460. Required: Compute the budgeted cost of purchases for each month in the second quarter. Complete the budgeted income statement for each month in the second quarter.

Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Internet across the United States. To keep costs down, CGC maintains a warehouse but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year: Expected monthly sales for April, May, June, and July are $160,000, $ 130,000, $250,000, and $70,000, respectively. Cost of goods sold is 50 percent of expected sales. CGC's desired ending inventory is 60 percent of the following month's cost of goods sold. Monthly operating expenses are estimated to be: Salaries: $35,000. Delivery expense: 5 percent of monthly sales. Rent expense on the warehouse: $3,500. Utilities: $700. Insurance: $360. Other expenses: $460. Required: Compute the budgeted cost of purchases for each month in the second quarter. Complete the budgeted income statement for each month in the second quarter.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter16: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 39P

See similar textbooks

Similar questions

An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1,200 batteries. The supplier pays $28 for each battery and estimates that the annual holding cost is 30 percent of the battery’s value. It costs approximately $20 to place an order (managerial and clerical costs). The supplier currently orders 100 batteries per month. What is the economic order quantity? Based on your answer above, how many orders will be placed per year using the EOQ? Determine the ordering, handling, and total inventory costs for the EOQ. Determine the effective annualized cost of financing for the following credit terms, assuming that (1) discounts are not taken, (2) accounts are paid at the end of the credit period, and (3) use 365=day year: a. 1/10, n/30; b. 3/10, n/30; c. 3/10, n/60; d. 2/10, n/90
Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. How many pitchers of each type must be sold to break even in the coming year? (Use contribution margin per unit to calculate breakeven units.)
Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. Crane, Inc., has just received a sales catalog from a new supplier that is offering plastic pitchers for $28. What would be the new contribution margin per unit if managers switched to the new supplier? What would be the new breakeven point if managers switched to the new supplier? (Use contribution margin per unit to calculate breakeven units. Round answers to 0 decimal places, e.g. 25,000.)
Phillip F lamm's Computer Store in Texas sells a printer for $200. Demand is constant during the year, and annual demand is forecasted to be 600 units. Holding cost is $20 per unit per year, whereas the cost of ordering is $60 per order.Currently, the company is ordering 12 times per year (50 units each time). There are 250 working days per yea r, and the lead time is 10 days.a) Given the current policy of ordering 50 units at a time, what is the total of the annual ordering cost and the annual holding cost?b) If the company used the absolute best inventory policy, what would be the total of ordering and holding costs?c) What is the reorder point?
A local electronic repair shop uses 15,000 units of mobile batteries each year. It costs RO 30 to place and receive an order. It cost of material is RO 15 per unit and carrying cost is 24% of the cost per unit. Calculate the Economic Order Quantity for the shop, number of orders and total inventory costs. 2. Beta Merchandising Company purchases mobiles directly from manufacturers and sells it to small retailers. The following transactions occurred during 2020: March, 21st: 80 mobiles on hand @ RO 40 each. May, 14th: 120 mobiles purchased @ RO 50 each. July, 10th: 80 mobiles purchased @ RO 60 each. September 16th: 50 mobiles purchased @ 80 each Alpha merchandising sold 300 mobiles during 2020 Required: Compute the Cost of Inventory sold during 2020 and the value of closing inventory under the following cost inventory methods. (a). First in, first out (FIFO) (b). Last in, first out (LIFO) (c) Average cost method
Sunland, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $25 and are sold for $35. Glass pitchers cost $24 and are sold for $45. All other costs are fixed at $572,000 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year.
A hardware store sells paint that has a demand of 9,706 gallons per year. The store purchases the paint from a supplier for 11.2 dollars per gallon The unit holding cost per year is 24 percent of the unit purchase cost. while the ordering cost is 175 dollars per order. The paint supplier has a lead time of 10 days. What is the annual ordering cost if the store uses the order quantity of 2,103 gallons per order? Assume EOQ model is appropriate. Use at least 4 decimal places.
Disk City, Inc. is a retailer for digital video disks. The projected net income for the current year is $1,760,000 based on a sales volume of 260,000 video disks. Disk City has been selling the disks for $19 each. The variable costs consist of the $8 unit purchase price of the disks and a handling cost of $2 per disk. Disk City’s annual fixed costs are $580,000. Management is planning for the coming year, when it expects that the unit purchase price of the video disks will increase 30 percent. (Ignore income taxes.) Q. What volume of sales (in dollars) must Disk City achieve in the coming year to maintain the same net income as projected for the current year if the unit selling price remains at $19? (Do not round intermediate calculations. Round your final answer to the nearest whole number.)
Caldwell Supply, a wholesaler, has determined that its operations have three primary activities: purchasing, warehousing, and distributing. The firm reports the following operating data for the year just completed: Caldwell buys 100, 100 units at an average unit cost of $11 and sells them at an average unit price of $21. The firm also has fixed operating costs of $250,100 for the year. Caldwell's customers are demanding a 11% discount for the coming year. The company expects to sell the same amount if the demand for price reduction can be met. Caldwell's suppliers, however, are willing to give only a 3% discount. Required: Caldwell has estimated that it can reduce the number of purchase orders to 690 and can decrease the cost of each shipment by $4 with minor changes in its operations. Any further cost savings must come from reengineering the warehousing processes. What is the maximum cost (i.e., target cost) for warehousing if the firm desires to earn the same amount of profit next…
"Disk City, Inc., is a retailer for digital video disks. The projected net income for the current year is $200,000 based on a sales volume of 200,000 video disks. Disk City has been selling the disks for $16 each. The variable costs consist of the $10 unit purchase price of the disks and a handling cost of $2 per disk. Disk City’s annual fixed costs are $600,000. Management is planning for the coming year, when it expects that the unit purchase price of the video disks will increase 30 percent. (Ignore income taxes.). "Required: 1.Calculate Disk City’s break-even point for the current year in number of video disks. 2.What will be the company’s net income for the current year if there is a 10 percent increase in projected unit sales volume? 3.What volume of sales (in dollars) must Disk City achieve in the coming year to maintain the same net income as projected for the current year if the unit selling price remains at $16? 4.In order to cover a 30 percent increase in…
XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR 2.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost? Round-up to the nearest integer a. 180 units O b. None is correct O c. 220 units O d. 199 units e. 500 units
Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of 25,750 and is capable of processing as many as 6,500 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,500 orders per year. The cost of each PC system is 1,100 per year. In addition to the salaries, Elliott spends 27,560 for forms, postage, and other supplies (assuming 26,000 purchase orders are processed). During the year, 25,350 orders were processed. Required: 1. Classify the resources associated with purchasing as (1) flexible or (2) committed. 2. Compute the total activity availability, and break this into activity usage and unused activity. 3. Calculate the total cost of resources supplied (activity cost), and break this into the cost of activity used and the cost of unused activity. 4. (a) Suppose that a large special order will cause an additional 500 purchase orders. What purchasing costs are relevant? By how much will purchasing costs increase if the order is accepted? (b) Suppose that the special order causes 700 additional purchase orders. How will your answer to (a) change?