Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please help me with this 10 questions its due sunday 1. Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company

can you please help me with this 10 questions its due sundayimage text in transcribed

1. Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next five months, the following sales billings are expected: May $84,000 June 100,800 July 77,000 August 86,800 September 91,000 Required: Hide Prepare a schedule showing the cash expected in payments on accounts receivable in August and in September. If an amount box does not require an entry, leave it blank or enter "0". Kailua and Company Schedule August September June: $ x $ July: $ x $ x $ August: $ x $ x September: $ x Total cash receipts $ $ 2. Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: a. Sales are budgeted to be $157,000. About 85% of sales are cash; the remainder are on account. b. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. c. Food and supplies purchases, all on account, are expected to be $116,000. La Famiglia pays 25% in the month of purchase and 75% in the month following purchase. d. Most of the work is done by the owners, who typically withdraw $6,000 a month from the business as their salary. (Note: The $6,000 is a payment in total to the two owners, not per person.) Various parttime workers cost $7,300 per month. They are paid for their work weekly, so on average 90% of their wages are paid in the month incurred and the remaining 10% in the next month. e. Utilities average $5,950 per month. Rent on the building is $4,100 per month. f. Insurance is paid quarterly; the next payment of $1,200 is due in October. g. September sales were $181,500 and purchases of food and supplies in September equaled $130,000. h. The cash balance on October 1 is $2,147. Required: 1. Calculate the cash receipts expected in October. $ 2. Calculate the cash needed in October to pay for food purchases. $ Hide 3. Prepare a cash budget for the month of October. La Famiglia Pizzeria Cash Budget For the Month of October Beginning balance Cash receipts Cash available $ $ Less: Payments for food and supplies purchases $ Owners' draw Workers' wages Utilities Rent Insurance Total disbursements $ Ending balance $ 3. Sales Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Required: Hide 1. Prepare a sales budget for each quarter of 2014 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer. Stillwater Designs Sales Budget For the Year Ended December 31, 2014 1st Qtr. S12L7: Units Price 2nd Qtr. 3rd Qtr. 4th Qtr. Sales S12L5: Units Price Sales Total sales 2. Conceptual Connection: How will Stillwater Designs use this sales budget? The input in the box below will not be graded, but may be reviewed and considered by your instructor. 4. Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Stillwater Designs needs a production budget for each product (representing the amount that must be outsourced to manufacturers located in Asia). Beginning inventory of S12L7 for the first quarter of 2014 was 340 boxes. The company's policy is to have 20% of the next quarter's sales of S12L7 in ending inventory. Beginning inventory of S12L5 was 170 boxes. The company's policy is to have 30% of the next quarter's sales of S12L5 in ending inventory. Required: Hide Prepare a production budget for each quarter for 2014 and for the year in total. Stillwater Designs Production Budget for S12L7 For the Year Ended December 31, 2014 1st Qtr. Sales Desired ending inventory 2nd Qtr. 3rd Qtr. 4th Qtr. Total Total needs Less: Beginning inventory Units produced Hide Stillwater Designs Production Budget for S12L5 For the Year Ended December 31, 2014 1st Qtr. Sales Desired ending inventory 2nd Qtr. 3rd Qtr. 4th Qtr. Total Total needs Less: Beginning inventory Units produced 5. Production Budget and Direct Materials Purchases Budgets PeanutFresh Inc. produces allnatural organic peanut butter. The peanut butter is sold in 12ounce jars. The sales budget for the first four months of the year is as follows: Company policy requires that ending inventories for each month be 20% of next month's sales. At the beginning of January, the inventory of peanut butter is 14,500 jars. Each jar of peanut butter needs two raw materials: 24 ounces of peanuts and one jar. Company policy requires that ending inventories of raw materials for each month be 10% of the next month's production needs. That policy was met on January 1. Required: Hide 1. Prepare a production budget for the first quarter of the year. Show the number of jars that should be produced each month as well as for the quarter in total. PeanutFresh Inc. Production Budget For the First Quarter of the Year January February March Total Sales Desired ending inventory Total needs Less: Beginning inventory Units produced Hide 2. Prepare a direct materials purchases budget for jars for the months of January and February. Do not include a multiplication symbol as part of your answer. PeanutFresh Inc. Direct Materials Purchases Budget for Jars For January and February January Production Jar Jars for production Desired ending inventory Total needs Less: Beginning inventory Jars purchased February Total Hide Prepare a direct materials purchases budget for peanuts for the months of January and February. Do not include a multiplication symbol as part of your answer. PeanutFresh Inc. Direct Materials Purchases Budget for Peanuts For January and February January Production Ounces Ounces for production Desired ending inventory Total needs Less: Beginning inventory Ounces purchased February Total 6. Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: Required: Hide 1. Prepare a schedule of cash receipts for July. Roybal Inc. Schedule of Cash Receipts For July Payments on account: From May credit sales: $ x % $ x % x % x % From June credit sales: $ From July credit sales: $ Less: July cash discount $ Cash receipts $ Hide 2. Prepare a schedule of cash receipts for August. Roybal Inc. Schedule of Cash Receipts For August Payments on account: From June credit sales: $ x % $ x % x % % From July credit sales: $ From August credit sales: $ Less: August cash discount $ Cash receipts x $ 7. Cash Payments Schedule Fein Company provided the following information relating to cash payments: a. Fein purchased direct materials on account in the following amounts: b. c. Fein pays 20% of accounts payable in the month of purchase and the remaining 80% in the following month. In July, direct labor cost was $32,300. August direct labor cost was $35,400. The company finds that typically 90% of direct labor cost is paid in cash during the month, with the remainder paid in the following month. d. August overhead amounted to $71,200, including $6,350 of depreciation. e. Fein had taken out a fourmonth loan of $15,000 on May 1. Interest, due with payment of principal, accrued at the rate of 9% per year. The loan and all interest were repaid on August 31. (Note: Use whole months to compute interest payment.) Required: Hide Prepare a schedule of cash payments for Fein Company for the month of August. Fein Company Schedule of Cash Payments For August August Payments on accounts payable: From July purchases $ x % $ x % x % From August purchases $ Direct labor payments: From July $ From August $ x % Overhead Loan repayment Cash payments $ 8. Structuring a MakeorBuy Problem Fresh Foods, a large restaurant chain, needed to determine if it would be cheaper to produce 5,000 units of its main food ingredient for use in its restaurants or to purchase them from an outside supplier for $12 each. Cost information on internal production includes the following: Fixed overhead will continue whether the ingredient is produced internally or externally. No additional costs of purchasing will be incurred beyond the purchase price. Required: 1. What are the alternatives for Fresh Foods? 2. List the relevant cost(s) of internal production and of external purchase. The input in the box below will not be graded, but may be reviewed and considered by your instructor. 3. Which alternative is more cost effective? By how much? $ 4. Now assume that 20% of the fixed overhead can be avoided if the ingredient is purchased externally. Which alternative is more cost effective? By how much? $ 9. Structuring a SpecialOrder Problem Harrison Ford Company has been approached by a new customer with an offer to purchase 10,000 units of its model IJ4 at a price of $5 each. The new customer is geographically separated from the company's other customers, and existing sales would not be affected. Harrison normally produces 75,000 units of IJ4 per year but only plans to produce and sell 60,000 in the coming year. The normal sales price is $12 per unit. Unit cost information for the normal level of activity is as follows: Fixed overhead will not be affected by whether or not the special order is accepted. Required: 1. What are the relevant costs and benefits of the two alternatives (accept or reject the special order)? The input in the box below will not be graded, but may be reviewed and considered by your instructor. 2. By how much will operating income increase or decrease if the order is accepted? by $ 10. Structuring a KeeporDrop Product Line Problem Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Hickory's management is deciding whether to keep or drop the parquet product line. Hickory's parquet flooring product line has a contribution margin of $50,000 (sales of $300,000 less total variable costs of $250,000). All variable costs are relevant. Relevant fixed costs associated with this line include 80% of parquet's machine rent and all of parquet's supervision salaries. Required: 1. List the alternatives being considered with respect to the parquet flooring line. 2. List the relevant benefits and costs for each alternative. The input in the box below will not be graded, but may be reviewed and considered by your instructor. 3. Which alternative is more cost effective? By how much? $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students also viewed these Accounting questions

Question

The relevance of the information to the interpreter

Answered: 1 week ago