Please provide solution to this problems using excel. Thank You.

Sugarland Brands packages single-sized servings of sugar and sugar substitute for fast food restaurants. The activities required to package sugar are fewer and less complex than for sugar substitute because the company manufactures sugar in house. The direct costs of producing the two products are as follows: D ire c t m a te ria ls D ire c t la b o r Sugar $ 0 .0 1 $ 0 .0 2 S u g a r S u b s titu te $ 0 .0 2 $ 0 .0 4 Overhead is currently assigned to the two products on the basis of machine hours. The following information is provided regarding overhead costs: TR A C EA BLE C O STS $ 7 5 ,0 0 0 C O ST D R IV E R N um ber of s e tu p s P a c k in g $ 1 2 5 ,0 0 0 N um ber of m a c h in e h o u rs In s p e c tio n $ 2 5 ,0 0 0 $ 2 2 5 ,0 0 0 N u m b e r o f b a tc h e s A C T IV IT Y S e tu p C O S T D R IV E R D A T A SU G A R SU G A R L IN E S U B L IN E T O T A L 50 100 150 1 0 ,0 0 0 1 5 ,0 0 0 2 5 ,0 0 0 200 300 500 1.) Compute the predetermined overhead rate under the current method of overhead cost allocation. How much total overhead cost will be assigned to each product under the current system? 2.) Compute the three activity rates that would be used in an activity-based system. How much total overhead cost will be assigned to each product under an ABC system? 3.) Assuming an ABC system to be more precise, by how much does the company's current costing system over or under cost the products? Be specific