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. 1. Expected monthly sales for April, May, June, and July are $250,000, $220,000, $340,000, and $120,000, respectively. 2. Cost of goods sold is 25 percent of expected sales. 3. CGC's desired ending inventory is 35 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: • Salaries: $33,000 Delivery expense: 7 percent of monthly sales Rent expense on the warehouse: $6,000 Utilities: $1,200 Insurance: $210 Other expenses: $310 Required: 1. Compute the budgeted cost of purchases for each month in the second quarter. April June Total cost of budgeted purchases 2. Complete the budgeted income statement for each month in the second quarter. CITRUS GIRL COMPANY Budgeted Income Statement For the Month Ending April 30 Budgeted Gross Margin May Budgeted Net Operating Income May 31 June 30

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. 1. Expected monthly sales for April, May, June, and July are $250,000, $220,000, $340,000, and $120,000, respectively. 2. Cost of goods sold is 25 percent of expected sales. 3. CGC's desired ending inventory is 35 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: • Salaries: $33,000 Delivery expense: 7 percent of monthly sales Rent expense on the warehouse: $6,000 Utilities: $1,200 Insurance: $210 Other expenses: $310 Required: 1. Compute the budgeted cost of purchases for each month in the second quarter. April June Total cost of budgeted purchases 2. Complete the budgeted income statement for each month in the second quarter. CITRUS GIRL COMPANY Budgeted Income Statement For the Month Ending April 30 Budgeted Gross Margin May Budgeted Net Operating Income May 31 June 30

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter3: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 10EB: Keleher Industries manufactures pet doors and sells them directly to the consumer via their web...

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
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
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.)
Betta Jets, a toy wholesaler, is hoping to expand into manufacturing its own products. The business owners have provided you with the following information: All sales are on credit. The company collects 70% in the month following the sale and 30% two months following the sale. All purchases of stock are paid for one month after the purchase. Equipment costing $250,000 is expected to be acquired and paid for in July. The selling and distribution expenses are $48 000 each month. Administrative expenses are $42 000 per month. This includes $5 000 of depreciation expense. Selling Expenses and Administrative Expenses are paid in the month they are incurred. The cash balance on 1 July 2022 is $28 000. The following sales and purchases data in 2022 have been compiled for the preparation of the budget: April May June July $ $ $ $ Purchases 300 000 360 000 340 000 400 000 Sales 800 000 860 000 840 000 880 000 REQUIRED: Prepare…
Hoffman Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 60,500 units per year, an ordering cost of $12 per order, and carrying costs of $1.20 per unit.a. What is the economic ordering quantity?___________Units b. How many orders will be placed during the year? __________Orders c. What will the average inventory be? ____________Units d. What is the total cost of ordering and carrying inventory? $____________
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?
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…
Green Tees, an on line retailer of t-shirts, orders 100,000 t-shirts per year from its manufacturer. Green Trees plans on ordering t-shirts several times over the next year. The firm receives 2,500 t-shirts each time it orders. The carrying cost is $0.10 per shirt per year. The order cost is $500 per order. What is the annual ordering cost of the t-shirt inventory (rounded to the nearest dollar)?
Phillips Corporation is a major manufacturer of food processors. It purchases motors from Viking Corporation. Annual demand is 52,000 motors per year or 1,000 motors per week. The ordering cost is $360 per order. The annual carrying cost is $6.50 per motor. It currently takes 2 weeks to supply an order to the assembly plant. Q. Now assume that demand can vary during the 2-week purchase-order lead time. The following table shows the probability distribution of various demand levels: Total Demand for Motors for 2 Weeks Probability of Demand (sums to 1) 1,600 0.05 1,800 0.20 2,000 0.50 2,200…
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
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. The annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. a) If the order quantity is 1000 gallons, what is the average inventory? b) If the order quantity is 1500 gallons, how many orders are placed each year? c) What is the EOQ quantity? d) If the order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for the EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost? f)If orders must be in integer multiples of 1000 gallons, how much should be ordered to minimize ordering and holding costs PER GALLON? g) A 3% purchase price discount is given if orders are for 8000 gallons or more. What would total annual costs (purchasing, ordering, and holding) be using this discount?