Review Home Insert Page Layout Formulut Data an Calibri vil vAA Copy B IU . .A. Format Painter ACCT1350 Assignment Template (2) 07 (1) - Excel View Help O Tell me what you want to do Weap Text General Merge Center - $ - % Conditional Format Formatting - Table Alignment Styles Number C D E F G H I J K 4 Marks) Question 2 (12 Marks) column tuse Shadow Awnings makes custom awnings for homes and businesses. The company uses an activity based costing system for its overhead costs. The company has provided the following data concering its annual overhead costs and its activity cost pools Overhead Costs Production overhead Office expense Total $150,000 $100.000 250000 Distribution of resource consumption, Activity Cost Pools Maling Job Awning Support Production overhead 45% 40% Office expense 699 Other 15% 27% Total 100% 100% The "Other activity cost pool consists of the costs of idle capacity and organization sustaining costs. The amount of activity for the year is as follows Cover Page 01 02 03 04 Type here to search o e wix"! E ! Painter merge Center 30 000 Formal Font Alignment Number 1 x R C D E F G H I J K L The "Other activity cost pool consists of the costs of idle capacity and organization sustaining costs. The amount of activity for the year is as follows: Activity Cost Pool Making Awnings Job Support Other Annual Activity 5.000 metres 200 jobs Not applicable Required a) Prepare the first stage allocation of overhead costs to the activity cost pools by filling in the table below (4 Marks). Suppe read Product Othey Tocal b) Compute the activity rates (ie, cost per unit of activity) for the Making Awnings and Job Support activity cost pools by filling in the table below (Marks) Cover Page 01 02 03 04 Type here to search o RH e . General Calberi BTU. viva . .A Wrap Text Merge & Center - $ - %, 8. Painter Font Alignment Number G H I J K L Making Anne Support Other Total Production Overhead Office Expand Total b) Compute the activity rates (ie, cost per unit of activity) for the Making Awnings and Job Support activity cost pools by filling in the table below (3 Marks) Making Awnings Job Support Production Overhead Office Expense Total 4) Prepare an income report in good form of a job that involves making 80 meters of awnings and has direct materials and direct labour cost of $3,000. The sales revenue from this job is $4,000. (5 Marks) Please answer Cover Page 91 1 02 03 04 be here to search