ACCA Applied Knowledge · Management Accounting · Spreadsheets
A management accountant wants to show how total monthly production cost of Kestrel Ltd is split between direct materials, direct labour and overheads, so that readers can see each element's share of the whole for a single month. Which chart type is most appropriate?
A pie chart is most appropriate because it shows each cost element as a share of one total for a single period. Line graphs show trends over time, scatter diagrams show relationships between variables, and histograms show frequency distributions, so none of those suit a one-month proportional split.
- APie chartCorrect
- BScatter diagram
- CLine graph
- DHistogram
Explanation
A pie chart displays each component as a proportion of a single total, which is exactly what is needed for one month's cost split. A line graph shows trends over time, a scatter diagram shows the relationship between two variables, and a histogram shows frequency distributions of continuous data.
Did you get it right without looking?
One question tells you little. A timed set on Spreadsheets shows your real accuracy, how long you take and where you lose marks.
More Spreadsheets questions
- A cost model has the formula =B5*C$2 in cell D5, where C2 holds the overhead rate per labour hour. The formula is copied down from D5 to D6 …
- A cost accountant has monthly sales units in cells B2:B13. She wants the average monthly sales volume, ignoring any blank cells. Which formu…
- In a spreadsheet, cell B2 contains the formula =A2*$D$1 and is copied down to cell B3. Which formula will appear in B3?
- In a spreadsheet, the finance team of Harbor plc has a table of cost data with 20 rows. They want to display only the rows where the cost ce…
- A budget model calculates total cost in cell F2 as =B2*C2+D2, where B2 is 500 units, C2 is a variable cost of $6 per unit and D2 is fixed co…
- A management accountant enters the formula =B2*C2 in cell D2 and copies it down to cell D3. Which formula will appear in D3?