itrus 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 $220,000, $190,000, $310,000, and $90,000, respectively. 2. Cost of goods sold is 30 percent of expected sales. 3. CGC's desired ending inventory is 20 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: Salaries: $30,000. Delivery expense: 4 percent of monthly sales. Rent expense on the warehouse: $4,500. Utilities: $800. Insurance: $175. Other expenses: $260. Required: 1. Compute the budgeted cost of purchases for each month in the second quarter. 2. Complete the budgeted income statement for each month in the second quarter.

itrus 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 $220,000, $190,000, $310,000, and $90,000, respectively. 2. Cost of goods sold is 30 percent of expected sales. 3. CGC's desired ending inventory is 20 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: Salaries: $30,000. Delivery expense: 4 percent of monthly sales. Rent expense on the warehouse: $4,500. Utilities: $800. Insurance: $175. Other expenses: $260. Required: 1. Compute the budgeted cost of purchases for each month in the second quarter. 2. Complete the budgeted income statement for each month in the second quarter.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Osborne 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: The data from the table are as follows: # of planters to be sold January: 3,400 February: 3,800 March: 3,300 April: 4,900 May: 4,600. Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month in the upcoming year should be equal to 25% of the following month’s budgeted sales. Each planter requires three pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month’s production on hand at the end of each month. The polypropylene costs $0.20 per pound. Requirements Prepare a production budget for each month in the first quarter of the year,…
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
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
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…
Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units for the upcoming months are as follows: July August September October Expected sales 10,000 12,000 8,000 14,000 Five ounces of plastic resin are needed to produce every case. Dolly likes to have enough plastic resin on hand at the end of the month to cover 20% of the next month’s production requirements. Dolly also likes to maintain a finished goods inventory equal to 10% if the next month’s estimated sales. How many units are required for production for the quarter ended September?
Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units for the upcoming months are as follows: July August September October Expected sales 10,000 12,000 8,000 14,000 Five ounces of plastic resin are needed to produce every case. Dolly likes to have enough plastic resin on hand at the end of the month to cover 20% of the next month’s production requirements. Dolly also likes to maintain a finished goods inventory equal to 10% if the next month’s estimated sales. How many units of plastic resin must be issued to production for the quarter ended September?
Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units for the upcoming months are as follows: July August September October Expected sales 10,000 12,000 8,000 14,000 Five ounces of plastic resin are needed to produce every case. Dolly likes to have enough plastic resin on hand at the end of the month to cover 20% of the next month’s production requirements. Dolly also likes to maintain a finished goods inventory equal to 10% if the next month’s estimated sales. What is the ending inventory of the finished goods on September?
Dolly Plastics Corporation manufactures and sells plastic casings. Expected casing sales (in units for the upcoming months are as follows: July August September October Expected sales 10,000 12,000 8,000 14,000 Five ounces of plastic resin are needed to produce every case. Dolly likes to have enough plastic resin on hand at the end of the month to cover 20% of the next month’s production requirements. Dolly also likes to maintain a finished goods inventory equal to 10% if the next month’s estimated sales. How many units of plastic resin requires to be purchased for August?
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
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? $____________
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?
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…