of the year: 1. Expected monthly sales for April, May, June, and July are $180,000, $150,000, $270,000, and $50,000, respectively. 2. Cost of goods sold is 45 percent of expected sales. 3. CGC's desired ending inventory is 55 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: . Salaries: $33,000. • Delivery expense: 8 percent of monthly sales. • Rent expense on the warehouse: $2,500. • Utilities: $500. • Insurance: $330. . Other expenses: $430. 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.

of the year: 1. Expected monthly sales for April, May, June, and July are $180,000, $150,000, $270,000, and $50,000, respectively. 2. Cost of goods sold is 45 percent of expected sales. 3. CGC's desired ending inventory is 55 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: . Salaries: $33,000. • Delivery expense: 8 percent of monthly sales. • Rent expense on the warehouse: $2,500. • Utilities: $500. • Insurance: $330. . Other expenses: $430. 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.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

Pietro 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?
Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Total Pops data show the following information: New machinery will be added in April. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next months requirements. Direct material requires 2 pounds per unit at a cost of $3 per pound. The ending inventory required for direct materials is 15% of the next months needs. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.
Ottis, 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 economic order quantity. 2. Compute the ordering, carrying, and total costs for the EOQ. 3. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?
Lowell Manufacturing Inc. has a normal selling price of 20 per unit and has been selling 125,000 units per month. In November, Lowell Manufacturing decided to lower its price to 19 per unit expecting it can increase the units sold by 16%. a. Compute the normal revenue with a 20 selling price. b. Compute the planned revenue with a 19 selling price. c. Compute the actual revenue for November, assuming 135,000 units were sold in November at 19 per unit. d. Compute the revenue price variance, assuming 135,000 units were sold in November at 19 per unit. e. Compute the revenue volume variance, assuming 135,000 units were sold in November at 19 per unit. f. Analyze and interpret the lowering of the price to 19.
Cadre, Inc., sells a single product with a selling price of $120 and variable costs per unit of $90. The companys monthly fixed expenses are $180,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of October when they will sell 10,000 units. How many units will Cadre need to sell in order to realize a target profit of $300,000? What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Construct a contribution margin income statement for the month of August that reflects $2,400,000 in sales revenue for Cadre, Inc.
Kerr Manufacturing sells a single product with a selling price of $600 with variable costs per unit of $360. The companys monthly fixed expenses are $72,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of January when they will sell 500 units. How many units will Kerr need to sell in order to realize a target profit of $120,000? What dollar sales will Kerr need to generate in order to realize a target profit of $120,000? Construct a contribution margin income statement for the month of June that reflects $600,000 in sales revenue for Kerr Manufacturing.
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?
Marlin Motors sells a single product with a selling price of $400 with variable costs per unit of $160. The companys monthly fixed expenses are $36,000. What is the companys break-even point in units? What is the companys break-even point in dollars? Prepare a contribution margin income statement for the month of November when they will sell 130 units. How many units will Marlin need to sell in order to realize a target profit of $48,000? What dollar sales will Marlin need to generate in order to realize a target profit of $48.000? Construct a contribution margin income statement for the month of February that reflects $200,000 in sales revenue for Marlin Motors.
Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided the following information about expenses anticipated for next year: The selling price of Poleskis single product is 16. In recent years, profits have fallen and Poleskis management is now considering a number of alternatives. Poleski wants to have a net income next year of 250,000, but expects to sell only 120,000 units unless some changes are made. The president of Poleski has asked you to calculate the companys projected net income (assuming 120,000 units are sold) and the sales needed to achieve the companys net income objective for next year. Also, compute Poleskis contribution margin per unit, contribution margin ratio, and break-even point for next year. The worksheet CVP has been provided to assist you. Note that the data from the problem have already been entered into the Data Section of the worksheet.
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.