Answer questions 1-15 in excel or word.

120.000 70.000 Budgeted unit sales books 50000 Selling price per unit s. what are the tors wwwwwwwwillactions for the year advised bud What is the tou required production for the year under the revised budget d whois the tossedoffed production The tip purchase "materials for the year ised by d. What are the total expected cash dust wements for raw materials for the year under this rey budget? abig seeing this mud . we mustaction manager coo more than 90,00ge limit quartcompleted budget. the Present can produce "ontity hits in given quarter, Is this a potential problem? If so, what can be done about it? ATIONAL 15 connect -3, masterton Company makes one product and it provided the following tinformation to help prepart -5, budgeted selling price per unit is $70. Budgeted unit sales salesare of crest, and Sept. ber are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit, e, puppy percent of credit sales are collected in the month of the sale among mine following my C. The ending finished goods inventory equals 20% of the following month's unit sales. he ending raw materials inventory equals 10% of the following month's raw materials pre mon needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materigod $2.00 per pound. Thirty percent of raw materials purchases are paid for in the month of purchase and 70% in the lowing month. 1. The direct labor wage rate is $15 per hour. Each unit of finished goods requires two labor-hours. g. The variable selling and administrative expense per unit sold is $1.80. The fixed selling and istrative expense per month is $60,000. Required: 1. What are the budgeted sales for July? 2. What are the expected cash collections for July? 3. What is the accounts receivable balance at the end of July? 4. According to the production budget, how many units should be produced in July? 5. If 61,000 pounds of raw materials are needed to meet production in August, how many po materials should be purchased in July? 6. What is the estimated cost of raw materials purchases for July? 7. In July what are the total estimated cash disbursements for raw materials purchases? As of raw material purchases in June is $88,880. 8. What is the estimated accounts payable balance at the end of July? 9. What is the estimated raw materials inventory balance at the end of July? 10. What is the total estimated direct labor cost for July?Sharpie Master Budgeting If we assume that there is no fixed manufacturing overhead and the variable manufacturing over is $10 per direct labor-hour, what is the estimated unit product cost 12. What is the estimated finished goods inventory balance at the end of July't 13. What is the estimated cost of goods sold and gross margin for July? 14. What is the estimated total selling and administrative expense for July 15. What is the estimated net operating income for July? CO EXERCISE 8-1 Schedule of Expected Cash Collections L08-2 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sal of each year, as shown in the company's sales budget for the second quarter given below: April May Jun Budgeted sales (all on account) $300,000 $500,000 $200 From past experience, the company has learned that 20% of a month's sales are of sale, another 70% are collected in the month following sale, and the remaini the second month following sale. Bad debts are negligible and can be ignore $230,000, and March sales totaled $260,000. Required: 1. Using Schedule 1 as your guide, prepare a schedule of expected ca and in total, for the second quarter. ble balance on June 30th