Mountainview Sporting Goods has the following sales budget: (Click the icon to view the sales budget.) Suppose Junesales are expected to be $76,000 rather than $60,000 Revise Mountainviewsales budget. Mountainview Sporting Goods Store Sales Budget Four Months Ended July 31 April Cash sales, 70% Credit sales, 30% Total sales Data table May June July Total Mountainview Sporting Goods Store Sales Budget www Four Months Ended July 31 April May June July Total Cash sales (70%) $ Credit sales (30%) 36,400 $ 15,600 18,000 59,500 $ 42,000 $ 36,400||$ 25,500 174,300 15,600 74,700 $ 52,000 $ 85,000 $60,000 $ 52,000 $ 249,000 Total sales - X

Mountainview Sporting Goods has the following sales budget: (Click the icon to view the sales budget.) Suppose Junesales are expected to be $76,000 rather than $60,000 Revise Mountainviewsales budget. Mountainview Sporting Goods Store Sales Budget Four Months Ended July 31 April Cash sales, 70% Credit sales, 30% Total sales Data table May June July Total Mountainview Sporting Goods Store Sales Budget www Four Months Ended July 31 April May June July Total Cash sales (70%) $ Credit sales (30%) 36,400 $ 15,600 18,000 59,500 $ 42,000 $ 36,400||$ 25,500 174,300 15,600 74,700 $ 52,000 $ 85,000 $60,000 $ 52,000 $ 249,000 Total sales - X

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 34E: A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and...

See similar textbooks

Similar questions

Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
Mango Place has forecast its sales for the coming months as follows: Standard Units 102 April May June July 121 139 162 The standard model sells for $214. Required: Prepare a sales budget for the quarter ending June 30. Budgeted unit sales Budgeted sales price Budgeted sales revenue Mango Place Sales Budget (Standard Model) For the Quarter Ending June 30 April May June Total
Imagine you are an owner of a company. Listed below are your budgeted monthly unit sales sold at P1o per unit. March April May June July Budgeted Monthly Unit 2,000.00 3,000.00 4,000.00 5,000.00 4,500.00 Sales Using the table below, prepare a sales budget for the month of April, May and June. Budgeted Sales Forecast Аpril Мay June Total Budgeted Monthly Unit Sales Unit Selling Price Sales Budget
Imagine you are an owner of a company. Listed below are your budgeted monthly unit sales sold at P10 per unit. March April May June July Budgeted Monthly Unit Sales 2,000.00 3,000.00 4,000.00 5,000.00 4,500.00 Using the table below, prepare a sales budget for the month of April, May and June. Budgeted Sales Forecast April May June Total Budgeted Monthly Unit Sales Unit Selling Price Sales Budget The beginning balance of Accounts Receivable amounted to P 10,000 which was fully paid in April. 80% of the monthly sales computed in the budgeted sales forecast are collected in the month of sale while 20% of sales are collected the following month. Using the table below, prepare a cash collection budget for the month of April, May and June. Cash Collection Budget April May June Total Accounts Receivable, beg.…
Hiking General Store prepared the following sales budget: MONTH BUDGETED SALES MARCH RM4,000.00 APRIL RM14,000.00 MAY RM12,000.00 JUNE RM16,000.00 The expected gross profit rate is 30% and the inventory at the end of February was RM14,000. Desired inventory levels at the end of the month are 10% of the next month Cost Of Good Sold. Compute the total purchase budgetedfor April for Hiking General Store. Support your answer with explaination.
The following information applies to questions 25 and 26 The sales budget for Fred Limited contains the following information: October November December Units 300 550 700 $ (thousands) 75,000 165,000 210,000 Sales are all on credit, with 30% collected in the month of sale and 70% in the following month. Finished goods inventory at the end of each month should be 58% of the following month's sales requirements. Prepare a finished goods inventory budget and use it to answer Following Calculate the closing finished goods inventory, in units, for October. Calculate the required production, in units, for October.
4. Prepare a direct labor cost budget for August. Newport Inc. Direct Labor Cost Budget For the First Quarter Ending August 31 June July August First Quarter hr. hr. hr. hr. hrs. hrs. hrs. hrs. X$ X$ X$ 5. Prepare a factory overhead cost budget for August. Newport Inc. Factory Overhead Cost Budget For the First Quarter Ending August 31 June July August First Quarter Variable factory overhead: hrs. hrs. hrs. hrs. X$ X$ X$ X$ Fixed factory overhead: Total factory overhead cost
Accounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…