4. Richard asks you to calculate the membership prices for the first quarter memberships sold in the gallery ticket office. The individual membership price is $50. Students pay a discounted price of $25. In cell F5, create a formula using the IF function to determine the membership price based on the following criteria: a. If cell D5 (the Category) is Student the price is 25. (Hint: Student must appear in quotes. Do not enter $ for the price.) b. All other individual members must pay 50. Copy the formula in cell F5 into the range F6:F13.

Max fischer is a beekeeper. his annual group insurance costs 11,700. his employer pays 60% of the cost. how much does max pay semimonthly for it?

Salty sensations snacks company manufactures three types of snack foods: tortilla chips, potato chips, and pretzels. the company has budgeted the following costs for the upcoming period: 1 factory depreciation $33,782.00 2 indirect labor 84,456.00 3 factory electricity 8,446.00 4 indirect materials 40,356.00 5 selling expenses 26,900.00 6 administrative expenses 17,200.00 7 total costs $211,140.00 factory overhead is allocated to the three products on the basis of processing hours. the products had the following production budget and processing hours per case: budgeted volume (cases) processing hours per case tortilla chips 3,600 0.25 potato chips 5,300 0.11 pretzels 2,300 0.49 total 11,200 required: a. determine the single plantwide factory overhead rate.* b. use the factory overhead rate in (a) to determine the amount of total and per-case factory overhead allocated to each of the three products under generally accepted accounting principles. refer to the amount descriptions list provided for the exact wording of the answer choices for text entries.* * if required, round your answers to the nearest cen

Xie company identified the following activities, costs, and activity drivers for 2017. the company manufactures two types of go-karts: deluxe and basic. activity expected costs expected activity handling materials $ 625,000 100,000 parts inspecting product 900,000 1,500 batches processing purchase orders 105,000 700 orders paying suppliers 175,000 500 invoices insuring the factory 300,000 40,000 square feet designing packaging 75,000 2 models required: 1. compute a single plantwide overhead rate, assuming that the company assigns overhead based on 125,000 budgeted direct labor hours. 2. in january 2017, the deluxe model required 2,500 direct labor hours and the basic model required 6,000 direct labor hours. assign overhead costs to each model using the single plantwide overhead rate.