Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please i need only the answers , some exercises are incomplete i cant find the other answers. thanks Cash Receipts The sales budget for Perrier
Please i need only the answers , some exercises are incomplete i cant find the other answers. thanks
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1 percent cash discount for payments made by customers during the month of sale. The accounts receivable balance on April 30 is $25,000, of which $6,000 represents uncollected March sales and $19,000 represents uncollected April sales. Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a threemonth summary of estimated cash collections. Perrier, Inc. Schedule of Budgeted Cash Collections Quarterly by Months May Total Cash receipts: June $Answer $Answer 0 0 July Total $Answer $Answer 0 0 Cash Disbursements Assume that Waycross Manufacturing manages its cash flow from its home office. Waycross controls cash disbursements by category and month. In setting its budget for the next six months, beginning in July, it used the following managerial guidelines: Category Guidelines Purchases Pay half in current and half in following month. Payroll Pay 90 percent in current month and 10 percent in following month. Loan Pay total amount due each month. Category Guidelines Payments Predicted activity for selected months follow: Category May June July August Purchases $30,000 $48,000 $52,000 $54,000 Payroll 100,000 130,000 140,000 100,000 Loan Payments 10,000 10,000 12,000 12,000 Prepare a schedule showing cash disbursements by account for July and August. Waycross Manufacturing Schedule of Cash Disbursements For the Months of July and August July August $Answer Accounts payable $Answer 0 Answer Payroll 0 Answer 0 Loan payments Answer 0 Answer 0 0 $Answer $Answer Total 0 0 Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 130,000 April 190,000 Februar y 160,000 May 190,000 March 190,000 June 230,000 Beginning inventory for 2010 is 40,000 units. The budgeted inventory at the end of a month is 20 percent of units to be sold the following month. Purchase price per unit is $3. Prepare a purchases budget in units and dollars for each month, January through May. The Music Shop Purchases Budget January - May, 2010 January February Answer Purchase units: Answer Answer 0 0 $Answer Purchase dollars: March $Answer 0 May Answer 0 $Answer 0 April 0 Answer 0 0 $Answer $Answer 0 0 Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 Februar y 210,000 April 190,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $41,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $20,000. Prepare monthly cash budgets for February, March, and April. Use negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers. Wilson's Retail Company Cash Budgets February, March, and April February March $Answer $Answer 20000 Cash balance, beginning April $Answer 0 0 Wilson's Retail Company Cash Budgets February, March, and April February Answer March April Answer 0 Answer 0 0 Total Cash receipts Answer Answer 0 Answer 0 0 Cash available Answer Answer 0 Answer 0 0 Total disbursements $Answer $Answer 0 $Answer 0 0 Cash balance, ending Production and Purchases Budgets in Units At the end of business on June 30, 2009, the Wooly Rug Company had 100,000 square yards of rugs and 300,000 pounds of raw materials on hand. Budgeted sales for the third quarter of 2009 are: Month Sales July 180,000 sq. yards August 200,000 sq. yards September 160,000 sq. yards October 160,000 sq. yards The Wooly Rug Company wants to have sufficient square yards of finished product on hand at the end of each month to meet 40 percent of the following month's budgeted sales and sufficient pounds of raw materials to meet 30 percent of the following month's production requirements. Five pounds of raw materials are required to produce one square yard of carpeting. Prepare a production budget for the months of July, August, and September and a purchases budget in units for the months of July and August. Wooly Rug Company Production Budget For the Months of July, August, & September, 2009 July August September Answer Answer Answer 0 Budgeted production - sq. yards 0 0 Wooly Rug Company Purchases Budget For the Months of July & August, 2009 July Purchases in pounds August Answer Answer 0 0 Cash Budget The Peoria Supply Company sells for $30 one product that it purchases for $20. Budgeted sales in total dollars for next year are $720,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $30,000 June 44,000 July 49,000 August 50,000 Account balances at July 1 include these: Cash $20,000 Merchandise inventory 15,000 Accounts receivable (sales) 24,000 Accounts payable (purchases) 13,000 The company pays for onehalf of its purchases in the month of purchase and the remainder in the following month. Endofmonth inventory must be 50 percent of the budgeted sales in units for the next month. A 2 percent cash discount on sales is allowed if payment is made during the month of sale. Experience indicates that 50 percent of the billings will be collected during the month of sale, 40 percent in the following month, 6 percent in the second following month, and 4 percent will be uncollectible. Total budgeted selling and administrative expenses (excluding bad debts) for the fiscal year are estimated at $174,000 , of which onehalf is fixed expense (inclusive of a $20,000 annual depreciation charge). Fixed expenses are incurred evenly during the year. The other selling and administrative expenses vary with sales. Expenses are paid during the month incurred. (Round your answers to the nearest whole number.) (a) Prepare a schedule of estimated cash collections for July. Peoria Supply Company Schedule of Cash Collections For the Month of July Current month's sales Previous month's sales Two months' prior sales Total cash collections $Answer 0 $Answer 0 $Answer 0 $Answer 0 (b) Prepare a schedule of estimated July cash payments for purchases. Peoria Supply Company Schedule of Cash Payments for Purchases For the Month of July Current month's purchases Beginning accounts payable Total cash payments $Answer 0 Answer 0 $Answer 0 (c) Prepare schedules of July selling and administrative expenses, separately identifying those requiring cash disbursements. Peoria Supply Company Schedule of Selling and Administrative Expenses and Cash Disbursements For the Month of July Total Cash Selling and administrative expenses: $Answer Fixed 0 $Answer Cash payment 0 Answer Variable Answer 0 Total expenses and cash disbursements $Answer 0 $Answer 0 0 (d) Prepare a cash budget in summary form for July. Peoria Supply Company Cash Budget For the Month of July $Answer Cash receipts 0 Cash disbursements: Merchandise Selling and administrative Excess receipts (disbursements) $Answer 0 Answer Answer 0 0 $Answer 0 Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010. PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 Assets Liabilities and Stockholders' Equity Cash $2,000 Accounts payable $26,000 Accounts receivable 25,000 Dividends payable 17,000 Inventory 30,000 Rent payable 1,000 2,000 Stockholders' equity 40,000 Total liabilities and equity $84,000 Prepaid Insurance Fixtures 25,000 Total assets $84,00 0 Actual and forecasted sales for selected months in 2010 are as follows: Month Sales Revenue January $80,000 February 50,000 March 40,000 April 50,000 May 60,000 June 70,000 July 90,000 August 80,000 Monthly operating expenses are as follows: Wages and salaries $27,000 Depreciation 100 Utilities 1,000 Rent 1,000 Cash dividends of $17,000 are declared during the third month of each quarter and are paid during the first month of the following quarter. Operating expenses, except insurance, rent, and depreciation are paid as incurred. Rent is paid during the following month. The prepaid insurance is for five more months. Cost of goods sold is equal to 50 percent of sales. Ending inventories are sufficient for 120 percent of the next month's sales. Purchases during any given month are paid in full during the following month. All sales are on account, with 50 percent collected during the month of sale, 40 percent during the next month, and 10 percent during the month thereafter. Money can be borrowed and repaid in multiples of $1,000 at an interest rate of 12 percent per year. The company desires a minimum cash balance of $2,000 on the first of each month. At the time the principal is repaid, interest is paid on the portion of principal that is repaid. All borrowing is at the beginning of the month, and all repayment is at the end of the month. Money is never repaid at the end of the month it is borrowed. (a) Prepare a purchases budget for each month of the second quarter ending June 30, 2010. Peyton Department Store Monthly Purchase Budget Quarter Ending June 30, 2010 April May $Answer June $Answer Total $Answer 31000 $Answer 36000 47000 114000 Budgeted purchases (b) Prepare a cash receipts schedule for each month of the second quarter ending June 30, 2010. Do not include borrowings. Peyton Department Store Schedule of Monthly Cash Receipts Quarter Ending June 30, 2010 April May $Answer June $Answer 46000 Total $Answer 54000 $Answer 64000 164000 Total cash receipts (c) Prepare a cash disbursements schedule for each month of the second quarter ending June 30, 2010. Do not include repayments of borrowings. Peyton Department Store Schedule of Monthly Cash Disbursements Quarter Ending June 30, 2010 April Total cash disbursements May $Answer June $Answer 72000 Total $Answer 60000 $Answer 65000 197000 Peyton Department Store Schedule of Monthly Cash Disbursements Quarter Ending June 30, 2010 April May June Total (d) Prepare a cash budget for each month of the second quarter ending June 30, 2010. Include budgeted borrowings and repayments. Only use negative signs, if needed, for: excess receipts over disbursements, balance before borrowings and cash balances (beginning and ending). Peyton Department Store Monthly Cash Budget Quarter Ending June 30, 2010 April May $Answer June $Answer 2000 Total $Answer 2000 2000 $Answer 0 Cash balance, beginning Answer Answer 46000 Answer 54000 Answer 64000 164000 Receipts Disbursements Answer Answer 72000 Answer 60000 Answer 65000 197000 Peyton Department Store Monthly Cash Budget Quarter Ending June 30, 2010 April May Answer June Answer -26000 Total Answer -6000 Answer -1000 -33000 Excess receipts over disb. Answer Answer -24000 Answer -4000 1000 Answer 0 Balance before borrowings Answer Answer Answer 0 0 0 Answer 0 Borrowings Answer Answer 0 Answer 0 Answer 0 0 Loan repayments Cash balance, ending $Answer $Answer 2000 $Answer 2000 $Answer 2000 6000 Peyton Department Store Monthly Cash Budget Quarter Ending June 30, 2010 April May June Total (e) Prepare an income statement for each month of the second quarter ending June 30, 2010. Only use negative signs to show net losses in income. Peyton Department Store Budgeted Monthly Income Statements Quarter Ending June 30, 2010 April May $Answer June $Answer 50000 Total $Answer 60000 $Answer 70000 180000 Sales Answer Answer 25000 Answer 30000 Answer 35000 90000 Cost of sales Answer Answer 25000 Gross profit Operating expenses: Answer 30000 Answer 35000 90000 Peyton Department Store Budgeted Monthly Income Statements Quarter Ending June 30, 2010 April Answer May Answer 27000 June Answer 27000 Total Answer 27000 81000 Wages and salaries Answer Answer 100 Answer 100 Answer 100 300 Depreciation Answer Answer 1000 Answer 1000 Answer 1000 3000 Utilities Answer Answer 1000 Answer 1000 Answer 1000 3000 Rent Answer Answer 400 Answer 400 Answer 400 1200 Insurance Interest Answer Answer 0 Answer 0 Answer 0 0 Peyton Department Store Budgeted Monthly Income Statements Quarter Ending June 30, 2010 April Answer May June Answer 0 Total Answer 0 Answer 0 0 Total expenses $Answer $Answer 0 $Answer 0 $Answer 0 0 Net income (f) Prepare a budgeted balance sheet as of June 30, 2010. Peyton Department Store Budgeted Balance Sheet June 30, 2010 Assets Liabilities and Equity $Answer $Answer 47000 2000 Cash Accounts receivable Merchandise payable Answer Dividend payable 41000 Answer 17000 Peyton Department Store Budgeted Balance Sheet June 30, 2010 Assets Liabilities and Equity Answer Answer 54000 Inventory 1000 Rent payable Answer Answer 800 Prepaid insurance 0 Loans payable Answer Answer 24700 Fixtures 0 Interest payable $Answer Answer 122500 Total assets 0 Stockholders' equity $Answer 0 Total liab. & equity Sales Variances Assume that Casio Computer Company, LTD. sells handheld communication devices for $100 during August as a backtoschool special. The normal selling price is $150. The standard variable cost for each device is $70. Sales for August had been budgeted for 400,000 units nationwide; however, due to the slowdown in the economy, sales were only 375,000. Compute the revenue, sales price, sales volume, and net sales volume variances. $Answer 0 Revenue Answer $Answer 0 Sales Price Answer $Answer 0 Sales volume variance Answer $Answer Net sales volume variance 0 Answer Materials Variances North Wind manufactures decorative weather vanes that have a standard materials cost of two pounds of raw materials at $1.50 per pound. During September 12,000 pounds of raw materials costing $1.57 per pound were used in making 5,700 weather vanes. Determine the materials price and quantity variance. Materials price variance $Answer 0 Answer Materials quantity variance $Answer Answer 0 Direct Labor Variances Assume that Nortel manufactures specialty electronic circuitry through a unique photoelectronic process. One of the primary products, Model ZX40, has a standard labor time of 0.5 hour and a standard labor rate of $15.50 per hour. During February, the following activities pertaining to direct labor for ZX40 were recorded: Direct labor hours used Direct labor cost Units of ZX40 manufactured 2,210 $40,000 4,800 (a) Determine the labor rate variance. $Answer 0 Answer (b) Determine the labor efficiency variance. $Answer 0 Answer (c) Determine the total flexible budget labor cost variance. $Answer 0 Answer Check Variable Overhead Variances Assume that the best cost driver that Sony has for variable factory overhead in the assembly department is machine hours. During April, the company budgeted 480,000 machine hours and $4,000,000 for its Texas plant's assembly department. The actual variable overhead incurred was $4,180,000, which was related to 500,000 machine hours. Do not round until your final answers. Round your answers to the nearest dollar. (a) Determine the variable overhead spending variance. $ Answer 0 U F 1.00 points out of 1.00 (b) Determine the variable overhead efficiency variance. $Answer 0 F UStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started