Croy Incorporated has the following projected sales for the next five months Sales in Units 3,450 3,860 4,510 4,190 3,900 Month April May June July August Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $3.40 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,655 pounds Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May 4

Croy Incorporated has the following projected sales for the next five months Sales in Units 3,450 3,860 4,510 4,190 3,900 Month April May June July August Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $3.40 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,655 pounds Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May 4

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

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?
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.
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?
Langstons 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?
Logo 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?
All 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?
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.
Croy Inc. has the following projected sales for the next five months: Month Salen in Unita 3,850 3,875 4, 260 4,135 3,590 April May June July August Croy's finished goods inventory policy is to have 60 percent of the next month's sales on hand at the end of each month, Direct materials cost $3.10 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,865 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of materials purchased for April and May.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,450 May 3,940 June 4,640 July 4,180 August 3,980 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $3.00 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,695 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of materials purchased for April and May.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,500 May 3,860 June 4,590 July 4,195 August 3,960 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,680 pounds. Required: 1. Determine budgeted production for April, May, and June. I figured out May 4,225 and June 4,393. How do you figure out April without knowing March units?
Croy Incorporated has the following projected sales for the next five months: Month Sales in Units April 3, 580 May 3,810 June 4, 640 July 4, 125 August 3,960 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,695 pounds. Required: Determine budgeted production for April, May, and June. Determine budgeted cost of direct materials purchased for April and May.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,500 May 3,860 June 4,590 July 4,195 August 3,960 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,680 pounds. Determine budgeted cost of materials purchased for April and May. (Use rounded Budgeted Production units in intermediate calculations. Round your answers to 2 decimal places.) 2. Determine budgeted cost of materials purchased for April and May. April May Budgeted Cost of Material Purchased