The men's buyer has June sales of $895,000 and June markdowns of $340,000. June BOM is $2,080,000 and July BOM is $1,700,000. The on order for June is $935,000. Calculate the remaining OTB for June. Planned Actual Over/Under June BOM Stock $2,080,000 June Sales $895,000 June MDs $340,000 July BOM Stock $1,700,000 June receipts Planned On order $935,000 Over/Under

The men's buyer has June sales of $895,000 and June markdowns of $340,000. June BOM is $2,080,000 and July BOM is $1,700,000. The on order for June is $935,000. Calculate the remaining OTB for June. Planned Actual Over/Under June BOM Stock $2,080,000 June Sales $895,000 June MDs $340,000 July BOM Stock $1,700,000 June receipts Planned On order $935,000 Over/Under

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

The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
A buyer's sales for October are estimated at $15,000. Her stock on October 1 is $38,000, and she has $21,600 stock at retail on-order for the month. Markdowns are planned at 8% for the month, and the planned EOM stock is $40,000. Can the buyer receive an additional order of $3,000 on October 15t? [Hint: Convert Markdown percent to Markdown in dollars, review chapter 3 or chapter 5 notes] Answer the following: a.) Open-to-buy at retail b.) Can the buyer receive an additional order?
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
The following sales information was extracted from the books of APEX Ltd during 2020. The company produces two products, Natural life and physical life. Sales forecast January- April 2020 Details January February March April Total Natural life 1,800 2,200 3,200 2,500 9,700 Physical life 2,200 1,700 1,500 2,700 8,100 Notes: The ending stock of finished goods each month is to be held equal to 20% of the forecasted sales for the next month. Raw material stocks at the end of each month are to be held at a level equal to twenty-five (25%) percent of the sales for that month. Sales for December 31, 2019 were Natural life 3,000 units; and Physical life 2,600 units. To make one unit of Natural life, five (5) units of raw material X12 are used, while four (4) units of raw material Z100 are used to make one unit of Physical life During 2020 the company sold one unit of Natural life for $650 and one unit of Physical life for $775. Budgeted sales for…
Raider-X Company forecasts sales of 18,000 units for April. Beginning inventory is 3,000 units. The desired ending inventory is 30% higher than the beginning inventory. How many units should Raider-X purchase in April?
Vertical Ladder Company (VLC) forecasts its sales for January through April will be $60,000, $70,000, $100,000, and $90,000, respectively. All sales are made on credit, and it is expected that 20 percent of sales will be collected in the month of the sale and the remainder will be collected the month following the sale. Customers who pay in the month of the sale will take the 4 percent cash discount VLC offers for paying early. VLC normally purchases and pays for raw materials, which cost 60 percent of sales, one month prior to selling the finished products. Employees' wages represent 30 percent of sales and rent is $4,000 per month. At the beginning of February, VLC expects to have $6,000 in cash, which is $2,000 greater than its target cash balance. Using the information provided, construct VLC's cash budget for February and March. Round your answers to the nearest dollar. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". February March…
Archer Electronics Company’s actual sales and purchases for April and May are shown here, along with forecast sales and purchases for June through September. Sales Purchases April (actual) $370,000 $155,000 May (actual) 350,000 145,000 June (forecast) 325,000 145,000 July (forecast) 325,000 205,000 August (forecast) 340,000 225,000 September (forecast) 380,000 220,000 The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale, and 50 percent are collected two months later. Archer pays for 20 percent of its purchases in the month after purchase and 80 percent two months after. Labor expense equals 15 percent of the current month’s sales. Overhead expense equals $12,500 per month. Interest payments of $32,500 are due in June and September. A cash dividend of $52,500 is scheduled to be paid in June. Tax payments of $25,500 are due in…
The home buyer is planning their basic towel assortment for the fall season. The sales plan is $304,800 with a planned turnover for the fall season of 0.96. The planned sales by month are: August $44,450 September $57,150 October $47,625 November $63,500 December $76,200 January $28,575 Calculate the basic stock needed for each month.
Sales in December (2019) were 4000 units @ sar10 per unit. Monthly sales for the first four months of the next year (2020) are forecasted as follows: Months units January 5,000 February 8,000 March 6, 000 April 5, 000 Unit selling price SAR 10 The following information given to you as follows: Normally 60% of sales are collected in the month incurred and the remainders are collected in the month following the sales. Dallah groups wants closing stock equals 10% of the following month’s budgeted sales in units. on December 31 st , 400 units were on hand. Material required for the required production units are 3,500 Mts , 4,500 Mts., and 6,500 Mts.…
Sales in December (2019) were 4000 units @ sar10 per unit. Monthly sales for the first four months of the next year (2020) are forecasted as follows: Months units January 5,000 February 8,000 March 6, 000 April 5, 000 Unit selling price SAR 10 The following information given to you as follows: Normally 60% of sales are collected in the month incurred and the remainders are collected in the month following the sales. Dallah groups wants closing stock equals 10% of the following month’s budgeted sales in units. on December 31 st , 400 units were on hand. Material required for the required production units are 3,500 Mts , 4,500 Mts., and 6,500 Mts.…
A June sales forecast projects that 5,500 units are going to be sold at a price of $10.50 per unit. The desired ending inventory of units is 10% higher than the beginning inventory of 650 units. Total June sales are anticipated to be: O $57,750 O $55,065 O $55,060 O $63,525 O $55,000 F2 F3 0+ $ M E R % 5 F6 D F7 F8 7