Problem 10.12 (102) Budget Relationships The accountant at Supreme Audio resigned while he wasin the midst of preparing the budget for 2021. His work papers indicated the following:Sales in 2020Expected sales in 2021Cost of sales, 2021Beginning inventoryEnding inventoryPurchasesAssumptions:Budgeted Sales and Inventory Purchases for 2021Quarter 1Quarter 2Quarter 3$256,000$300,000$290,000$320,000$$192,000$ 84,000$Quarter 4$368,000$Total$1,214,000RequiredFill in the missing information to determine the sales and purchases budgets for 2021.SSS$Sales will increase by 25 percent over 2020.Cost of sales equals 75 percent of sales.For 2021, ending inventory should equal 35 percent of the cost of sales for the next quarter.Sales in the first quarter of 2022 will be $300,000.

Budgeting is a systematic and strategic financial planning process that involves creating a detailed…

Problem 10.12 (L02) Budget Relationships The accountant at Supreme Audio resigned while he was in the midst of preparing the budget for 2021. His work papers indicated the following: Sales in 2020 Expected sales in 2021 Cost of sales, 2021 Beginning inventory Ending inventory Purchases Assumptions: Budgeted Sales and Inventory Purchases for 2021 Quarter 1 Quarter 2 Quarter 3 $256,000 $300,000 $290,000 $320,000 S $192,000 $ 84,000 $ $ $ $ Quarter 4 $368,000 $ $ Total $1,214,000 Required Fill in the missing information to determine the sales and purchases budgets for 2021. $ $ $ Sales will increase by 25 percent over 2020. Cost of sales equals 75 percent of sales. For 2021, ending inventory should equal 35 percent of the cost of sales for the next quarter. Sales in the first quarter of 2022 will be $300,000.

Problem 10.12 (L02) Budget Relationships The accountant at Supreme Audio resigned while he was in the midst of preparing the budget for 2021. His work papers indicated the following: Sales in 2020 Expected sales in 2021 Cost of sales, 2021 Beginning inventory Ending inventory Purchases Assumptions: Budgeted Sales and Inventory Purchases for 2021 Quarter 1 Quarter 2 Quarter 3 $256,000 $300,000 $290,000 $320,000 S $192,000 $ 84,000 $ $ $ $ Quarter 4 $368,000 $ $ Total $1,214,000 Required Fill in the missing information to determine the sales and purchases budgets for 2021. $ $ $ Sales will increase by 25 percent over 2020. Cost of sales equals 75 percent of sales. For 2021, ending inventory should equal 35 percent of the cost of sales for the next quarter. Sales in the first quarter of 2022 will be $300,000.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 33E: A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent...

See similar textbooks

Similar questions

A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971
Question The management accountant at Miller Merchandising & More, Odail Russell is in the process ofpreparing the cash budget for the business for the fourth quarter of 2021. It is customary for thebusiness to borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the…
Question The management accountant at Miller Merchandising & More, Odail Russell is in the process ofpreparing the cash budget for the business for the fourth quarter of 2021. It is customary for thebusiness to borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the saleii) Expected purchases…
Question Question The management accountant at Miller Merchandising & More, Odail Russell is in the process ofpreparing the cash budget for the business for the fourth quarter of 2021. It is customary for thebusiness to borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 ii) Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are settled as follows, in accordance with the credit terms –2/30, n60:60% in the month in which the inventory is purchased40% in the following month Required:(a)…
Question The management accountant at Miller Merchandising & More, Odail Russell is in the process ofpreparing the cash budget for the business for the fourth quarter of 2021. It is customary for thebusiness to borrow money during this quarter. Extracts from the sales and purchases budgets areas follows:Month cash sales sales on account purchasesAugust $85,000 $640,000 $420,000September $70,000 $550,000 $550,000October $88,550 $600,000 $500,000November $77,160 $800,000 $600,000December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the saleii) Expected purchases…
Required information [The following information applies to the questions displayed below.] Lamonte Company reports the following budgeted December 31 adjusted trial balance. Debit $ 52,200 122, 200 66, 200 127,200 Cash Accounts receivable Merchandise inventory Equipment Accumulated depreciation-Equipment Accounts payable Loan payable Common stock Retained earnings (beginning year balance) Sales Cost of goods sold Loan interest expense Depreciation expense Salaries expense Totals LAMONTE COMPANY Budgeted Income Statement For Year Ended December 31 Gross profit Selling, general and administrative expenses 362,200 10, 200 12, 200 124, 200 $ 876,600 Prepare the budgeted income statement for the current year ended December 31. Ignore income taxes. $ Credit 0 0 $ 27,200 36,200 24, 200 205,500 61,300 522, 200 $ 876,600
Dear Bartleby, can you please assist with solving the following item enclosed, thank you. Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 112,000 $ 136,000 $ 152,000 Cost of goods sold* 76,800 91,200 100,800 Gross profit $ 35,200 $ 44,800 $ 51,200 Operating expenses† 17,600 20,000 21,600 Operating income $ 17,600 $ 24,800 $ 29,600 *Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead).†Includes all period costs (i.e., selling, general, and administrative expenses).The company expects about 40% of sales to be cash transactions. Of sales on account, 65% are expected to be collected in the first month after the sale is made, and 35% are expected to be collected in the second month after sale. Depreciation, insurance, and property taxes represent $9,600 of the estimated monthly cost of goods…
Bramble Corp. reported the following information for 2022: Budgeted purchases October November December $260000 $296000 $318000 • Operating expenses are: Salaries, $110000; Depreciation, $30000; Rent, $20000; Utilities, $28000 • Operating expenses are paid during the month incurred. • Accounts payable is used only for inventory acquisitions. What are budgeted cash disbursements for operating expenses in November? $158000 $454000 $149000 O $188000
Dear Bartleby, can you please help with "calculations for cost of goods sold/operating expenses occured in the following problem, for March, April, May and June, thank you. Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 112,000 $ 136,000 $ 152,000 Cost of goods sold* 76,800 91,200 100,800 Gross profit $ 35,200 $ 44,800 $ 51,200 Operating expenses† 17,600 20,000 21,600 Operating income $ 17,600 $ 24,800 $ 29,600 *Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead).†Includes all period costs (i.e., selling, general, and administrative expenses).The company expects about 40% of sales to be cash transactions. Of sales on account, 65% are expected to be collected in the first month after the sale is made, and 35% are expected to be collected in the second month after sale. Depreciation,…
QUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…
Question 1 From the following information prepare a monthly cash budget for the three months ending 31st Dec.2020 Sales Materials Wages Production Admin. Selling, etc Month (RM) (RM) (RM) (RM) (RM) June 6,000 3,600 1,300 450 320 July 6,500 4,000 1,500 450 320 Aug. 7,000 4,800 1,500 500 350 Sep. 7,500 4,500 1,500 600 350 Oct. 8,000 4,600 1,600 600 400 Nov. 8,500 5,000 1,800 700 400 Dec. 9,000 5,200 2,000 700 450 Credit terms Sales 3 months to debtors. 10% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material – 2 months. Lag in payment Wages. 1/4 month, overheads 1/2 month. Other information Plant and Machinery to be installed in Aug. at a cost of RM30,000. It will be paid for by monthly installments of RM1,000 each from 1st Oct.; Preference share dividend @ 6% on RM100,000 are to be paid on 1st Dec. Calls on 500 equity shares @ RM2 per share expected on 1st November; Dividends from…
ONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade…