Delete the ServiceDate field from the Average By Month query. Add a new column using the Expression Builder. Create a formula to extract the name of the month from the ServiceDate field using a combination of the DatePart and MonthName functions. Name the column Month, and move the Month field to the left of the NumInParty field. Run the query. Save and close the query. What would be the formula for this?

Tina is applying for the position of a daycare assistant at a local childcare center. which document should tina send with a résumé to her potential employer? a. educational certificate b. work experience certificate c. cover letter d. follow-up letter

Shelby company produces three products: product x, product y, and product z. data concerning the three products follow (per unit): product x product y product z selling price $ 85 $ 65 $ 75 variable expenses: direct materials 25.50 19.50 5.25 labor and overhead 25.50 29.25 47.25 total variable expenses 51.00 48.75 52.50 contribution margin $ 34.00 $ 16.25 $ 22.50 contribution margin ratio 40 % 25 % 30 % demand for the company’s products is very strong, with far more orders each month than the company can produce with the available raw materials. the same material is used in each product. the material costs $8 per pound, with a maximum of 4,400 pounds available each month. required: a. compute contribution margin per pound of materials used. (round your intermediate calculations and final answers to 2 decimal places.) contribution margin per pound product x $ product y $ product z $ b. which orders would you advise the company to accept first, those for product x, for product y, or for product z? which orders second? third? product x product y product z

In each of the cases below, assume division x has a product that can be sold either to outside customers or to division y of the same company for use in its production process. the managers of the divisions are evaluated based on their divisional profits. case a b division x: capacity in units 200,000 200,000 number of units being sold to outside customers 200,000 160,000 selling price per unit to outside customers $ 90 $ 75 variable costs per unit $ 70 $ 60 fixed costs per unit (based on capacity) $ 13 $ 8 division y: number of units needed for production 40,000 40,000 purchase price per unit now being paid to an outside supplier $ 86 $ 74 required: 1. refer to the data in case a above. assume in this case that $3 per unit in variable selling costs can be avoided on intracompany sales. a. what is the lowest acceptable transfer price from the perspective of the selling division? b. what is the highest acceptable transfer price from the perspective of the buying division? c. what is the range of acceptable transfer prices (if any) between the two divisions? if the managers are free to negotiate and make decisions on their own, will a transfer probably take place?