Using the following information, create the following budgets for January, February and March: the production budget, the direct materials budget, the direct labour budget and the overhead budget for Williams Inc., a Calgary-based motor vehicle wheel manufacturer for its new XLR tire. The marketing department thinks that it will have strong sales. It usually keeps 20% of the next quarter's sales as a target ending inventory. For new products, Williams Inc. requires a target ending inventory of 30% of the next quarter's sales. Unfortunately, they were unable to manufacture any units before the end of the current year. March 20000 30000 45000 April 25000 Jan. Feb. If Williams Inc.uses14 kg of direct materials (rubber and metal) for each wheel it manufactures at a total cost of $5.00. It pays a total of $2200 in labour wages per hour among 100 employees. It takes 30 minutes of total labour time to produce one wheel. Overhead costs are $5 for direct materials for each labour hour per month. It pays $12,000 per month in rent and insurance.

Using the following information, create the following budgets for January, February and March: the production budget, the direct materials budget, the direct labour budget and the overhead budget for Williams Inc., a Calgary-based motor vehicle wheel manufacturer for its new XLR tire. The marketing department thinks that it will have strong sales. It usually keeps 20% of the next quarter's sales as a target ending inventory. For new products, Williams Inc. requires a target ending inventory of 30% of the next quarter's sales. Unfortunately, they were unable to manufacture any units before the end of the current year. March 20000 30000 45000 April 25000 Jan. Feb. If Williams Inc.uses14 kg of direct materials (rubber and metal) for each wheel it manufactures at a total cost of $5.00. It pays a total of $2200 in labour wages per hour among 100 employees. It takes 30 minutes of total labour time to produce one wheel. Overhead costs are $5 for direct materials for each labour hour per month. It pays $12,000 per month in rent and insurance.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required a. October sales are estimated to be $340,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. b. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. c. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month's cost of goods sold. However, ending inventory of December is expected to be $12,900. Assume that all purchases are made…
Rida, Inc., a manufacturer in a seasonal industry, is preparing its direct materials budget for the second quarter. It plans production of 240,000 units in the second quarter and 52,500 units in the third quarter. Raw material inventory is 43,200 pounds at the beginning of the second quarter. Other information follows: Direct materials. Each unit requires 0.60 pounds of raw material, priced at $175 per pound. The company plans to end each quarter with an ending inventory of materials equal to 30% of next quarter's budgeted materials requirements. Prepare a direct materials budget for the second quarter. (Enter "per unit" answers in two decimal places.) Units to be produced RIDA INC. Direct Materials Budget Second Quarter Materials needed for production (pounds) Total materials requirements (pounds) Materials to be purchased (pounds) Budgeted cost of direct materials purchases 240,000 units
Majan company has budgeted sales in units for the next five months as follows: June 5,400 units July 6,500 units August 7,000 units September 8,200 units October 4,800 units Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory on May 31 is 400 units. The company needs to prepare a Production Budget for the next five months. The total number of units to be produced in August is a. 7,120 units b. 7,420 units c. 7,170 units d. 8,520 units W P
Sherman has budgeted sales for the upcoming quarter as follows: April: 1, 600 units May: 1,900 units June: 1,750 units The desired ending finished goods inventory for each month is one - half of next month's budgeted sales. Three pounds of direct material are required for each unit produced. If direct material costs $5 per pound, and must be paid for in the month of purchase, the budgeted direct materials purchases (in dollars) for May are: Group of answer choices $1,975 $9, 875 $27, 750 $13, 875
Fillmore, Inc., expects sales of its housing for electric motors to be $82,000, $72,000, and $89,000 for January, February, and March, respectively. Its variable selling and administrative expenses are 11 percent of sales, and fixed selling and administrative expenses are $14,000 per month. Compute Fillmore's selling and administrative expense budget for January, February, and March. Budgeted selling and administrative expenses January February March
Empire Records Incorporated is a music retail store that began operations on January 1, Year 1. The company has budgeted sales as indicated in the following table. The company expects a 5 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. The company expects 50% of the sales on account to be collected in the month of sale with the remaining 50% collected in the month following the sale. Required: a. Complete the sales budget by filling in the missing amounts. b. What are the expected total cash receipts for the month of February? Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. January February March Sales Budget Cash sales Sales on account Total budgeted sales $ 63,200 140,000 203,200 0 0 Required B >
Shamrock Shades purchases sunglasses from bulk discounters and sells the sunglasses in mall kiosks throughout the Pacific Northwest. Shamrock is in the process of budgeting for the coming year and has projected sales of $360,000 for January, $440,000 for February, $600,000 for March, and $640,000 for April. Shamrock's desired ending inventory is 55 percent of the following month's cost of goods sold. Cost of goods sold is expected to be 45 percent of sales. Required: Compute the required purchases for each month of the first quarter (January through March). January Required Purchases February March
o Flexible Budgeting) Meadow Company produces hand tools. A sales budget for the next four months is as follows: March 10,300 units, April 13,900 units, May 16,900 units, and June 21,700 units. Meadow Company's ending finished goods inventory policy is 15% of the following month's sales. March 1 beginning inventory is projected to be 1.545 units. How many units will be produced in March? Multiple Choice 10.300 10.840 13,900 Help Save & Exit Submit 9,760
Shakira Inc. sells drones. The company is in the process of preparing its Selling and Administrative Expense Budget for the year. The following budget data are available: Variable Cost Per Drone Sold Monthly Fixed Cost Sales commissions $0.40 $ 12,000 Shipping 3.20 Advertising 0.25 Executive salaries 60,000 Depreciation on office equipment 4,000 Expenses are paid in the month incurred. If the company has budgeted to sell 20,000 drones in July, how much is the total budgeted selling and administrative expenses for July?
Perez Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Perez has budgeted sales as indicated in the following table. The company expects a 12 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Perez will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Round intermediate calculations and final answers to 2 decimal places.) Sales January February March $ 46,000 116,000 Cash sales Sales on account Total budgeted sales $ 162,000
COVID19Co produces hand tools. A sales budget for the next four months is as follows March10.700 units, April 13.600, May 16,200, and June 21.200 COVID19Co's ending finished goods inventory policy is 10% of the following month's sales. What is budgeted ending finished goods inventory for March?
Furniture, Inc. makes and sells a single product called a Bik. The company wants to prepare the direct material budget for the quarter ending June 30. Budgeted production of Biks for the next six months is as follows: February 14,000 Units March 15,500 Units April 11,900 Units May 12,600 Units June 14,500 Units July 16,000 Units It takes three yards of Material A to make one Bik. The company wants to maintain monthly ending inventory of Material A equal to 20% of the following month's production needs. On March 31, 2,000 yards of Material A were on hand. The cost of Material A is $5 per yard. Required: 1. Prepare the Direct Materials Budget for April, May, June, and quarter. 2. Based on the direct material budget that you prepared in requirement 1 above and assume that the direct materials purchase in February was $150,000 and in March was $160,000. Prepare the cash disbursements budget for April if the company policy for paying purchases is as follows: 10% in the month of purchase.…