Question please show all work on excel  The monthly sales for Yazici Batteries, Inc., were as shown in the above table. a) Forecast January sales of the coming year using each of the following: i. Naive method ii. 3-mth moving average iii. A 6-month weighted moving average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. iv. Exponential smoothing using an alpha \( =0.3 \) v. A trend projection model b) With the data given, which method would you recommend for this data set and why? c) Discuss the trend projection model that you obtained for this data set.

t AY 2- - 1 Use the graph of the function f to solve the inequality. (a) f(x) > 0 (b) f(x) so

Shelly and Kelly Macdonald met up with Sarah and Tara MacNeill to go fishing in Cape Breton. They found two pools in a stream containing speckled trout (assume equal variance), with the Macdonalds at one pool and the MacNeills at the other, and at the end of the day each team had caught (and released unharmed) 5 fish. For each fish they recorded the length and weight, and the data on length (in cm) is summarized below (Give the answers to 2 places past decimal) Team Macdonald MacNeill Mean 19 Std.Dev 1.6 21.24 2 a.) What is the pooled estimate of the variance? b.) Calculate the 95% confidence interval for the difference in mean length Lower: Upper:

The specific heat of lead is 0.030 cal/g⋅°C. 300 g of lead pellets at 100 °C are mixed with 100 g of water at 70 °C in a thermally insulated container. The final temperature of the mixture isData: specific heat of water = 1 cal/g⋅°CChoose an option:a) 72.5 °Cb)100 °Cc) 74.5°Cd) 85.5 °Ce) 79.5 °C

helpppp a 2. Suppose consumer consumes two goods, and y and has utility function U(x,y)=xyU(xy)=xy. He has a budget of $400. The price of x is Px=$10 and the price of y is Py=$20. (a) Find his optimal consumption bundle. (b) What happens when the when the income rises to B=800, other factors remaining constant?

Question B2 Manufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Use Figure B.1 for this exercise. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Assumptions A supplier can exist without providing components. • A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components.

Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April $ 810,000 567,000 243,000 May $ 950,000 665,000 285,000 June $ 650,000 455,000 195,000 July $ 560,000 392,000 168,000 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income 95,000 52,500 147,500 95,500 114,000 74,200 188,200 $ 96,800 76,000 56,000 47,000 53,000 123,000 109,000 $ 72,000 $ 59,000 $ *Includes $37,000 of depreciation each month. b. Sales are 20% for cash and 80% on account. C. Sales on account are collected over a three-month period with 10% collected in the month of sale; 70% collected in the first month following the month of sale; and the remaining 20% collected in the second month following the month of sale. February's sales totaled $305,000, and March's sales totaled $320,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month's inventory purchases are paid for in the month of purchase. The remaining 50% is paid in the following month. Accounts payable at March 31 for inventory purchases during March total $146,300. e. Each month's ending inventory must equal 20% of the cost of the merchandise to be sold in the following month. The merchandise inventory at March 31 is $113,400. f. Dividends of $44,000 will be declared and paid in April. g. Land costing $56,000 will be purchased for cash in May. h. The cash balance at March 31 is $66,000; the company must maintain a cash balance of at least $40,000 at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $200,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: 1. Prepare a schedule of expected cash collections for April, May, and June, and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for April, May, and June. b. A schedule of expected cash disbursements for merchandise purchases for April, May, and June, and for the quarter in total. 3. Prepare a cash budget for April, May, and June as well as in total for the quarter.