
9. Complete the following sales and inventory purchase budgets for 2018, assuming the following: • •...
3. Complete the following sales and inventory purchase budgets for 2018, assuming the following: • . Sales will increase by 25 percent over 2017 year. Cost of sales equals 75 percent of sales of expected sales in 2018. For 2018, ending Inventory should equal 35 percent of the cost of sales for the next quarter. Expected Sales in the first quarter of 2019 will be $150,000. BUDGETED SALES AND INVENTORY PURCHASES FOR 2018 Total Quarter 1 $128,000 Quarter 2 $150,000...
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 $320,000, $290,000, $410,000, and $190,000, respectively. 2. Cost of goods sold is 50 percent of expected sales. 3. CGC's desired...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...
1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...
Assessment Task 3 - Operating & cash budgets for a manufacturer Assessment scenario Sparks Pty Ltd has requested your assista nce in preparing their budgets. The demand for the product they manufacture and sell is seasonal and peaks in the third quarter. They have provided you with the following information relating to their forecasts and expectations for 2018 and the first half of 2019: Spark's product retails at $8 per unit. Budgeted sales for the 2018 year and first half...
Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $262,500 and accounts payable of $148,500. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $225,000 July $ 135,000 June 240,000 August 120,000 September 150,000 October 180,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected...
Payne Company provided the following information relevant to its inventory sales and purchases for December Year 1 and the first quarter of Year 2: Dec. Year 1 Jan. Year 2 Feb. Year 2 Mar. Year 2 (Actual) (Budgeted) (Budgeted) (Budgeted) Cost of goods sold $ 80,000 $ 140,000 $ 180,000 $ 120,000 Desired ending inventory levels are 25% of the following month's projected cost of goods sold. The company purchases all inventory on account. January Year 2 budgeted purchases are...
SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
What if Clapton Company in Example 9-1 changed their desired ending inventory level to equal 20.5% of next quarter's budgeted sales instead of 20%. How many budgeted units would be produced in the 3rd quarter (July- September)? Round your answer to the nearest whole unit. Clapton Company's sales budget shows the following projections for the year ending December 31, 2017: Quarters First (Jan - March) Second (April - June) Third (July - Sept) Fourth (Oct - Dec) Total Guitars 30,000...
What if Clapton Company in Example 9-1 changed their desired ending inventory level to equal 14.7% of next quarter's budgeted sales instead of 20%. How many budgeted units would be produced in the 3rd quarter (July-September)? Round your answer to the nearest whole unit. Example #1 PRODUCTION BUDGET Clapton Company's sales budget shows the following projections for the year ending December 31, 2017: Quarters First (Jan-March) Second (April - June) Third (July-Sept) Fourth (Oct-Dec) Total Guitars 30,000 40,000 22,500 27,500...